Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

BigInt strange behaviour visuals

Hey,

I'm experiencing the following issue:

 

I've got a table with a bigint (eg. 18014398509485096) as the primary key. This is ID is then used throughout the model and seems to work fine. I can see that everything is fine in the query editor and data view. However, when viewing the id's in the table matrix, the ID's seem to jump up and down, for instance 18014398509485096 is shown as 18014398509485095, etc, etc. This is also true when using drillthrough filters, so when selecting a drill through on ID 18014398509485096, the filter value shows 18014398509485095 but the correct object is shown.... Data exports are also severely mangled, showing the wrong ID's...

 

IMO this requires immediate attention for obvious reasons.

 

Thanks! 

Status: Accepted
Comments
v-qiuyu-msft
Community Support

Hi @mpadros,

 

I can reproduce this issue, and already report it internally: CRI 50691611. Will update here once get any feedback. 

 

 

Best Regards,
Qiuyun Yu

Vicky_Song
Impactful Individual
Status changed to: Accepted
 
mpadros
Frequent Visitor
Thank you!
v-qiuyu-msft
Community Support

Hi @mpadros,

 

I got below response from PG team: 

 

By-Design. Number is beyond PowerBI limitations.

This is a limitation for PowerBI in general due to JavaScript limitations.
The maximum number that can be "safely" handled is 9007199254740991 (2^53 - 1)

 

Best Regards,
Qiuyun Yu