Rounding during the data import

[dlibiani]

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.

[Ashish_Mathur]

Hi,

In the Query Editor, change the Data type of that field/column to Decimal number.

[lbendlin]

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-...
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/1447523