Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

convert latitude and longitude to zip code

I'm new to Power BI and attempting to use gps coordinates to create a new variable ("zipcode") in a database.  Is there a way to convert latitude and longitude data to zip code?  Many thanks.

2 Replies

  • affan's avatar
    affan
    Icon for Solution Sage rankSolution Sage

    Hi Anonymous

     

    If you are having a database of global zip code polygon, then you can use power bi to lookup the zip code from the long and lat data.

     

    However power bi itself will not convert the long/lat into the zip code.

     

    If you don't have this data then you can look into bing services for this.

     

    If this helped you, please mark this post as an accepted solution and like to give KUDOS .

     

    Regards,

    Affan

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you Affan.  I don't have a database of global zip codes that you mention, so I'll look into Bing services.  Will let you know how it goes.