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

Hey all,

 

I was able to get the zipcode list to work in my visualization by using the advance editor and changing the zipcode data type to "text".  Hope this helps.

 

Geoff

  • 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