Forum Discussion
Rounding during the data import
Hi All,
I have a rounding issue during the data import. Once the import is done, figures are automatically rounded. Here is an example :
Extract of PowerBI :
Extract of .xls file :
I already tried to change the format of the table (Decimal Number - 2) but it's still not working.
I also tried to change the regionnal settings, but I don't exactly know what exactly I have to change.
Thank you in advance for the help.
2 Replies
Please provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Hi,
In the Query Editor, change the Data type of that field/column to Decimal number.
