Forum Discussion
Solved
PowerBI imports Postal code as number
Hello.
When i importa data from MySQL, PowerBI bringss Postal Codes a a number an i loose the firsts "0". Then i canot use it as a location.
Even if i convert it to text, i don't have the figures.
How can i avoid it?
Thanks.
JoviAut , Open Power Query (Home Tab--> Transform data -> Transform Data) and check the steps and make sure It text from very first change type step
1 Reply
JoviAut , Open Power Query (Home Tab--> Transform data -> Transform Data) and check the steps and make sure It text from very first change type step