clickhouse-odbc icon indicating copy to clipboard operation
clickhouse-odbc copied to clipboard

Published 20 hours ago • verified publisher icon ClickHouse

Connect Power BI problems

Open DandelionWenjing opened this issue 7 years ago • 3 comments

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

DandelionWenjing avatar Jul 04 '18 06:07 DandelionWenjing

@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.

blinkov avatar Sep 10 '18 10:09 blinkov

Okay, thanks.

DandelionWenjing avatar Sep 11 '18 01:09 DandelionWenjing

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

filimonov avatar Nov 12 '19 21:11 filimonov