Forum Discussion
Number Values being distorted after changing type from Any to Text using Power Query
I am importing an Excel spreadsheet that has Column 1 data that Power BI reads as type 'Any'. I want to convert it to 'Text', but it distorts some of the values, as shown in Column 2.
| Column 1 (ABC/123) | Column 2 (text) | |
| 1000.001 | 10000.001 | ok |
| 10.01.01 | 10.01.01 | ok |
| 100 | 100.0000999998 | wrong |
If its an issue with the Excel column data type, I cannot change that.
Please advice!
amitchandak , are you suggesting adding a decimal at the end so as to convert it to type text directly in Excel? I am really trying to find a solution without tampering with my source Excel or its data.
I just found this article that highlights the issue I am having, and not sure if there's a resolution -
https://community.powerbi.com/t5/Power-Query/Strange-Data-Type-Conversion-from-Number-to-Text/td-p/990027
2 Replies
- amitchandak
Super User
Anonymous , Change column one to a number in excel and add a decimal place, it might have that value internally
amitchandak , are you suggesting adding a decimal at the end so as to convert it to type text directly in Excel? I am really trying to find a solution without tampering with my source Excel or its data.
I just found this article that highlights the issue I am having, and not sure if there's a resolution -
https://community.powerbi.com/t5/Power-Query/Strange-Data-Type-Conversion-from-Number-to-Text/td-p/990027
