Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Zip codes from database do not map

Hi,   We have several databases with US zip codes and none of these map in power BI.  However, if I export the data from the database into an excel file and put it in a table, then the zip codes ...
Need Help
JCLink8888's avatar
JCLink8888
Helper I
9 years ago

I am having the exact same issue, and nothing seems to work.

 

I have set my Postal Code column as text, but it still imports to BI without the lead 0.

 

I've even done a Concatenate 0 + postal code as text, and it still won't import properly.

 

Modeling the column to Postal Code also is not fixing it.

 

Creating a heirarchy with either the State, Country, or both also is not fixing the problem.

 

I am super curious what the solution is.

qburke's avatar
qburke
New Member
9 years ago

Also having issues here. 

Truncating leading zeros and does not like alpha-numeric postal codes from Canada