odbc connector error

[Dandelion0124]

 Hi all,

I have installed the Clickhouse ODBC driver in windows and configured the DSN for it.

I want to connect this ODBC in Power BI desktop:

The table can be showed while can not be loaded because of the error like follows:

I don't think this error is come from the odbc driver because I have tested the SQL command in Microsoft ODBC Test tools and can get the correct result:

So I think it may caused by the different definition between odbc driver and Power BI desktop. But I don't know how to solve it.

It would be great if someone have met that before.

Thanks a lot.

Wenjing Zhao

[v-chuncz-msft]

@Dandelion0124,

The message seems straightforward, but also try the Unicode driver.

[Dandelion0124]

Hi sam,

Thanks for your reply.

I have tried also the Unicode driver but met the same problem:

If I changed the type from Int64 to Int32, the error is gone. But the clickhouse odbc driver declared that they support the Int64.

So I don't know why.

Thanks.

Wenjing Zhao