search

ClickHouse / clickhouse-odbc

ODBC driver for ClickHouse
https://clickhouse.tech
Apache License 2.0
252 stars 88 forks source link

Connect Power BI problems #89

Open DandelionWenjing opened 6 years ago

DandelionWenjing commented 6 years ago

Hi all,

Thanks for providing this odbc driver. We have build this driver successfully in windows and tried to use Power BI to connect clickhouse odbc. When trying to load the table to Power BI using direct query mode, we have met the error:

"we can not convert the value null to type table"

While our table have no null values.

I have found that the dremio odbc driver may have the same problem and they have fixed it. https://community.dremio.com/t/cannot-convert-the-value-null-to-type-table/679

So if it is possible that this clickhouse odbc driver have something incompatible with Power BI?

Thanks. Wenjing

blinkov commented 6 years ago

@DandelionWenjing Could you please try the latest ODBC driver (https://github.com/yandex/clickhouse-odbc/releases ) which added the NULL support? Note that it also requires pretty recent clickhouse-server release.

DandelionWenjing commented 6 years ago

Okay, thanks.

filimonov commented 5 years ago

@DandelionWenjing can you give some feedback, does PowerBI work with ClickHouse?