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.

In the transform view, it shows that the 'location' column's type is binary. I changed it to number manually.

Then I can see the location column

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