Showing results for 
Search instead for 
Did you mean: 
New Member

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.

Solution Sage
Solution Sage

Re: convert latitude and longitude to zip code

Hi @gdsjohn


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 .




New Member

Re: convert latitude and longitude to zip code

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.

Helpful resources


Microsoft Ignite

This will be a conference that you do not want to miss!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Don't miss the Power BI Dev Camp this week!

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors