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
ashishrj's avatar
ashishrj
Power Participant
10 years ago

Anonymous Many a times zipcodes, latitude/longitude, city, states and country only maps data if that matches with those available in Bing map as Power BI uses Bing map. So see the proper format and name if that can be mapped in Bing then it should definitely work in Power BI. Hope this helps!

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Thank you for the reply,

     

    How do I ensure this?  I already have the 5 digit zip codes set to 'Text' data type and "Postal Code" under the modeling tab...is there something else that I should be doing?  The odd part is that only a handful of zip codes in the Northeastern US map but nothing else in the entire US....This is something that is crucial.

     

    Thank you,

     

     

    • compuag's avatar
      compuag
      New Member
      10 years ago

      Curious if you were able to resolve your issue.  I'm having the exact same problem.

      • DominikPetri's avatar
        DominikPetri
        Advocate V
        10 years ago

        The zip codes might also exist in other coutries. Have you tried combining the zip code with country code like

        DE-35260 (where DE is the ISO country code for Germany)?

         

        Best regards (from Germany) :-)

        Dominik.