Forum Discussion
Why is power query adding extra numbers to data from excel?
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
Thank you for your feedback, I checked both the excel file for the fields and confirmed that they are saved as text. I also checked the data type in Power Query and confirmed that it's saved as text. Please help as I can't use this column as a unique identifier/relationship
Hi Anonymous ,
Would you mind providing an Excel file with no private information? I would like to test the [Project#] column in Power Query Editor, thanks in advance.
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
Please let me know if you can access the below
https://1drv.ms/x/s!AnS3coMvk-0jgbFMbdtW7oOqY4f7sQ?e=KuoTFs
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.
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_GaoIf 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
Thank you, I will post with them. In the meantime I suppose doing a replace values may help, a lot of them have similar extra digits so hopefully that will eliminate it from the thousands of ones that aren't matching up.
please note I also tried to create a new query in hopes that I altered something in one of the steps but it pulled in with the same data and all of the extra numbers.