How to do web scrapping of Google Location Geo Co-ordinates using power query

[kumshan_1988]

I want to extract Geo Coordinates of the location mentioned in the attached file using Google API Key. For Eg In Google Search, Geo  Co-ordinates for Hisar location is 29.1492 and 75.7217 respectively. Using Google API key, There is a possibility of multiple Geo Co-ordinates for Hissar locations. I want to get the single result of Geo Co-ordinates values as received using Google Search. 

Also wanted to know how to do web scrapping of the same using power query.  

Please find attached the sample file - https://drive.google.com/file/d/1gXcAtxaDd16jW230cVtyIH1kiYbRfmKY/view?usp=sharing

[v-xuding-msft]

Hi @kumshan_1988 ,

Maybe these can help you:

Map locations with Google Maps API in Power BI Desktop (Part 3) 

PowerBI: How to Get Address by Passing Existing Coordinates to Google Maps Reverse Geocoding API