Power Query – get GPS info for places, using Google API
This tutorial describes, how to get GPS coordinates for places (addresses, cities, countries...) in Power Query.
Get the API key
You need a key from Google (or similar provider). Let´s see this:
It´s free in reasonable numbers of addresses.
You need table with info about place. Then add this custom column with syntax like this:
- Json.Document(Web.Contents("https://maps.googleapis.com/maps/api/geocode/json?key=YOUR_KEY_IS_HERE&address=" & [Place]))
Then drill it to lowest level:
If you go to the end, and possibly remove unnecessities, you have a result like this: