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.
