Power BI issue with big integer

[BIanon]

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.

[amitchandak]

@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)

[BIanon]

Thank you for your reply.

Unfortunately the error persists when using float as well

[tex628 · Accepted solution]

Here we go:
Data types in Power BI Desktop - Power BI | Microsoft Learn 

Appears to be Javascript limitations. 

/ J

[tex628]

Hi @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

[BIanon]

Thank you for this thorough and detailed response.

Your findings are consistent with what I am exepriencing and explains why I am unable to search an ID copied from a visual in the tables in data view.

If you find out more I would be interested in your findings.