Resolving the ERR.DS_API.FORMULA.TRANSLATION.DATA_TYPE error

Issue descriptionIssue description

When you connect directly to Yandex Metrica data from DataLens, you see this error message:

{
    "*******_result": {
        "code": "ERR.DS_API.FORMULA.TRANSLATION.DATA_TYPE",
        "status": 400,
        "sourceType": "bi_datasets",
        "message": "Invalid argument types for function <fuction>; 
        dialect: METRIKAAPI; types: (STRING);  however, the ClickHouse database supports such function.",
        "details": {}
    }
}
"Error: Request failed with status code 427\n)"

SolutionSolution

Such an error occurs when the direct connection to Yandex Metrica does not support the function you use. You can review the list of supported functions here.

To enable support for most functions, you can export data to ClickHouse® and connect to the database. To learn how to do this, see our DataLens FAQs here.

If the issue persistsIf the issue persists

If the tips we provided above did not help you resolve the issue, create a support ticket.
Provide the following information in your ticket:

1. Link to your dashboard in DataLens.
2. Description of how you use it.