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
AS it is ID, I think you aren't going to aggreagate it, and it will not be a problem if you set this column as Text
These long ids are in every table and sometimes multiple times. The data type detection worked perfectly on import and I really don't want to have to change all the data types to text to make multiple table relationships work. I need PowerBI to not round the number. It seems like it should not do that if the type is int64.
