Forum Discussion
Power BI issue with big integer
Hello Community,
I have some integer keys generated by running a hashing function on some really long strings.
The keys comes into Power Query just fine, but when I load the data into PBI the last 3 numbers are replaced by zeroes.
Here is an example of a key:
-9223335268985614144
And here is the same key after being loaded into PBI:
-9223335268985614000
The column data type is whole number and it is not being changed in data view either. What can I do to align this?
If need be I can provide more examples or information.
The hash function used is FARM_FINGERPRINT() in Big Query.
Here we go:
Data types in Power BI Desktop - Power BI | Microsoft Learn
Appears to be Javascript limitations.
/ J
5 Replies
BIanon , Can load it as decimal and try , change data type in Power query and in DAX use format as whole number (not data type)
Thank you for your reply.
Unfortunately the error persists when using float as wellHi BIanon ,
Ive done some testing and things are slightly weird.
It seems like the 18-digit code is still imported and stored. Its's just being displayed as a 15-digit code when visualized:
Data view:Same table in report view:
Relationships still work as intended, even through the keys are displayed as the same:Still, i don't know why they are displayed in this way. I'll do some more research and see what i can find.
Br,
J
