Int64 support
Posted: Thu 30 Jan 2020 23:44
I am using ODBC driver to connect SQLite to Power BI (or excel). The issue is Int64 value is truncated to 32 bits. F.x.:
6269010728497363496 = 0x5700000AFD32BA28
-8358680861215162072 = 0x8C00000AFC6A0128
are presented as
-47007192 = 0xFFFFFFFFFD32BA28
-60161752 = 0xFFFFFFFFFC6A0128
The data type set to whole number in P BI that is Int64
How to fix the problem?
6269010728497363496 = 0x5700000AFD32BA28
-8358680861215162072 = 0x8C00000AFC6A0128
are presented as
-47007192 = 0xFFFFFFFFFD32BA28
-60161752 = 0xFFFFFFFFFC6A0128
The data type set to whole number in P BI that is Int64
How to fix the problem?