Conversion error for Int64

ClickHouse / power-bi-clickhouse

This connector allows you to retrieve data from ClickHouse directly into Power BI for analysis and visualization

Apache License 2.0

46 stars 1 forks source link

Closed BentsiLeviav closed 10 months ago

BentsiLeviav commented 11 months ago

(moving discussion from #3) @pshtiwan-hassan and @morSchmidt receive an error when trying to aggregate Integer64 fields.

@morSchmidt indicated that this could be reproduced with our dataset

@UnamedRus suggested to disable the conversion on the connector side by doing something like

eliempje commented 10 months ago

Any update? I've the same issue.

BentsiLeviav commented 10 months ago

As @UnamedRus pointed out, the issue was that PowerBI's default behavior is to use CONVERT, while Clickhouse's conversion method is used by CAST.

I overrode the proper config. PR #13

I tested the changes with our uk-price-paid dataset.