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
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