Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ，

 

After testing, perhaps the problem lies in the data of the EXCEL workbook. This is beyond my knowledge and you can ask questions here.

Microsoft Excel Community

In the meantime, I will continue to look for the cause of the problem, and I will get back to you as soon as there is progress.

 

Best Regards,
Community Support Team_Gao

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems with it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data