Forum Discussion
decarsul
Helper V
Helper VIssue: queryM automatically adds leading zeros that should not exist
Good day, Today i been importing excel files and come across an issue i haven't had before. For some reason, during the table / column transform step my key columns are transformed from text to ...
Are you certain the leading zero's are being added by your query?
Are those leading zero's present at the initial step in Power Query before any transforms?
Are the leading zero's present in the Source file (excel)?
Please post an example of what you see in the actual Source file (Excel), what you are seeing the first Applied Step in PQ, and what you want as an outcome.
ToddChitt
Super User
Super UserExcel recently added the feature to retain leading zeros in cells that have them, like Zip Codes. If your data came through Excel, I would verify the source data BEFORE it went through Excel and see if it did anything unwanted to the data. In my experience, I try to keep data out of Excel when bringing it into Power BI. I have seen Excel do stuff that totally messes up data.