Forum Discussion

Dandelion0124's avatar
Dandelion0124
Frequent Visitor
8 years ago

odbc connector error

 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

Need Help

2 Replies

    • Dandelion0124's avatar
      Dandelion0124
      Frequent Visitor
      8 years ago

      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