whole number adds digits

[IanCockcroft]

Hi guys,

a number coming from a SQL source gets 2 zeros added to the end.

the model is right

any idea why?

in modelon report

[V-pazhen-msft · Accepted solution]

@IanCockcroft 

This is the known issue that is by design because numbers use floating point, certain values can't be represented with full precision in table / matrix visual, with my test, a cell with over 16 digits will be rounded up.

Also there is also limitation on the length of the digits in the data table. Please refer the to Number Types section. 
Data types in Power BI Desktop - Power BI | Microsoft Docs 

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[IanCockcroft]

Sorry, es  its numeric.

i changed it to whole to see if that was the issue.

[amitchandak]

@IanCockcroft , I doubt the whole number as datatype is used. Can change it to decimal and check if you have not tried that. I do face an issue with 15 digits whole numbers. That was key, I was able to take it as a string.