Forum Discussion
Why is power query adding extra numbers to data from excel?
For instance, the excel file which is the data source states 31800044.0307 but in power query it's showing 31800044.030699998. both data types are text in excel and in power query. this is occurring...
Issue was with the file, once the report was opened in xls it tried to transform the project number and was causing the error. I have pulled the original files in using text/csv
Anonymous , the Decimal number does approximation (Binary to decimal conversion). So you can see those differences. In Column tools limit the decimal places, You will see same output
Thank you for your response. However, since these are project numbers some of them may be 123456.01 or 123456.002 or 123456.1 so I cannot just decrease the decimal to the same amount for the entire column. Is there another solution?