Hello
I have a database which I use but getting issues in power query when the data starts with zero .
In power query all the leading zeros are removed, I have tried format to text before using power query but still the same issues .
Any ideas how can this can be solved
This is just because powerquery instant understand these are number while these values are in excel sheet as text leading with 0. You can change it in power query as well, in power query editor see the header and left side you will see 123; just click on the same and change it numbers to text.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Thank you , save me from tedious work
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks