Hi @MAAbdullah47,
I use Google Geocoding in my web application development work, having wrapped the Geocoding API in an ASP.NET page into which I pass the address parameters. I do this on an individual record basis, so it doesn’t handle massive numbers of records at once.
I reviewed the link you provided, and it does include all the information to get you started with reverse geocoding, or the standard geocoding that I do. The fact that you can do it directly in Power BI is amazing because it means you do not need to create your own custom method of calling the API for each record in the data source before loading it into Power BI.
You will need to use the links in that article to learn about setting up the Google account, getting the API key, and the functions needed to call the API itself. There is no easy way around that learning, and the article already provides a step-by-step once you have the account configured.
What I can do is give you a couple tips about the Google account itself. First, they just changed their licensing so that you have to set up a billing account in case you go over the allotted free usage level. The pricing guide can be found here. The API Key instructions can be found here.
The free usage level is basically staying under the $200 credit they give each month. I believe that is something like 100,000 requests. Given that you have 300,000 coordinates, you will exceed the free level. If you then repeat all those requests each time the report loads, that will get expensive. So, you’re best bet is figuring out a way to reverse geocode the coordinates one time each.
An alternative may be to find a service that will take your file of coordinates and convert it en masse. Please post back with any info you have on a final solution.
John C. Pratt
