PowerBI imports Postal code as number

[JoviAut]

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.

[amitchandak · Accepted solution]

@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