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
manzanolife's avatar
manzanolife
New Member
9 years ago

I was also able to get this to work by changing FROM Postal Code TO Uncategorized...completely backwards but worked.

RobinATX's avatar
RobinATX
New Member
8 years ago

hi,

 

I have a list of zip codes for Travis County Texas...

esri doesn't recognize 30 of the zip codes..

 

i am able to map all the other

why is this?

 

and yes, they are text.. 

thanks.

Robin

  • 4Eric's avatar
    4Eric
    Frequent Visitor
    8 years ago

    The ones that don't map are they 5 digit or the 9 digit.  I found on my ESRI map the 9 digit codes are not mapping.  That is what brought me here looking for an answer.  This might help narrow the scope of your problem.

     

    Eric

    • 4Eric's avatar
      4Eric
      Frequent Visitor
      8 years ago

      Did some testing with other visuals and found that 9 digit zip codes wouldn't work.  Went into my data made all zip code entries 5 digits.  Now all entries map and the totals based zip code are correct.  Not sure when this became a problem for me, but I am on the Jan. version.  I hope this helps someone...  

       

      Eric