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.
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
I guess that will become a support ticket then :).
The problem I see is that when I try to change the detect type, it will inserted as a new step. This new step can only placed after the navigation step. On that point, it is already too late. Besides, there are also article codes with .####. These will be changed to .### by your suggestion. Something I don't want to happen either :).
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.