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

      • 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