Forum Discussion
Floating point error when importing data
Someone at the office found the answer for my problem. Apparently to highlight the Excel cell with format 'text' is not sufficient enough to set it as text. You first have to trim it. Then this green triangle appears in the corner. When you import that data, it will remove it.
Perhaps this will also solve similar issues for others.
Hi DouweMeer
It seems you may check the 'locale for import'.Here are the articles about it.
https://www.qumio.com/Blog/Lists/Posts/Post.aspx?ID=50
Regards,
Cherie
v-cherch-msft , some product codes that are like numbers, will be imported correctly. To my opinion, it has nothing to do with the decimal to be a ',' or a '.'. Main reason besides why I can't change this, is that the company works with the '.' decimal for numbers as well.
Got any other suggestions?
Hi DouweMeer
I cannot reproduce the same issue.Could you provide the .pbix file and the data for us to test or show some screenshots about your issue?You can upload the .pbix file to OneDrive and post the link here. Do mask sensitive data before uploading.
Regards,
This is a selection of the items available. Further on in the same file there are related list prices with as decimal seperator the '.'.
Power BIExcel with text formatThese are numbers in the Excel source file
Hi DouweMeer
There're two ways for you to try.
First: Change the value format to text in query editor.
Second: Use Decimal Number format and set the number as 3.
If possible,please share a test .pbix file for us to check or submit a support ticket.
https://powerbi.microsoft.com/en-us/support/
Regards