search

ClickHouse / clickhouse-odbc

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

Int64 columns are loaded as binary columns in PowerBI #445

Open nudles opened 1 month ago

nudles commented 1 month ago

ClickHouse version: 24.7.1.2092 ODBC version: 1.2.1.20220905 PowerBI version: 2024 July Table DDL

CREATE TABLE `Store`
(
    location Int64,
    name String
)
ENGINE = MergeTree()
ORDER BY (location);

After creating the table, I tried to load it from PowerBI via ODBC driver. However, only the 'name' column is visible. The LocationID column is missing. img_v3_02cs_45b7bade-8286-4bf9-b169-5281c624achu

img_v3_02cs_bfff7591-5277-4fd1-abe3-51b27305a2hu

In the transform view, it shows that the 'location' column's type is binary. I changed it to number manually. img_v3_02cs_7d548409-266f-46e7-b082-fe0cbebde0hu

Then I can see the location column

img_v3_02cs_a4d7363a-e3f2-4171-be16-861c9cf8e0hu

The question is how can we change ODBC driver to fix the data type mapping? Thank you!

nudles commented 1 month ago

I also tried columns of other data types, including Int32, UInt32, UInt64. Only Int32 column can be displayed. All other columns are recongized as Binary column by PowerBI.

nudles commented 1 month ago

Hi @traceon , could you please give some hints on how to debug/fix this issue? Thank you!