cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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.

2 REPLIES 2
Highlighted
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 .

 

Regards,

Affan

Highlighted
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

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors