Forum Discussion
Solved
Long ID number rounding
I have an interesting issue popping up in my newest data source. The tables I am bringing into the data set contain long id numbers. The numbers type in Power Querry is int64. In PowerBI they are Who...
Hi lawsonbe
I confirm the problem and created an issue here https://community.powerbi.com/t5/Issues/Unexpected-long-numbers-round-in-Table-visual/idi-p/1082517#M56541. you can vote for
But solution in your case is to change date type to string in Power QUery mode, it helped me
Hi lawsonbe ,
It is a similar problem in Excel.
If you only want to show it in report, you could transform the data type as text. Or you could refer to the following DAX:
FORMAT( 'Table'[ID], "000000000000000000" )If you want to calculate the result based on these values, you could change them as scientific numbers.