Hi! I've built a process in Power Query that takes a list of lat/long coordinates, runs them through the Google Maps API, and returns a list of likely associated businesses. For a list of 10 lat/long coordinates, I can see from my Power Query results that I ultimately made, say, 50 calls to the Google Maps API. However, when I check the Google API dev console, it says I did something like 150 requests. I'm suspecting there's some duplicate calls being made as part of the refresh process, but want to better understand why this might be happening. The extra calls are not related to me editing the dataflow and calling the API as part of the preview in Power Query. I've tried using Table.Buffer in my tables, admittedly not knowing what exactly that does, but it hasn't made any impact on the # of calls, although it has reduced the refresh time by ~75%.
More detail on my process:
1. Get list of lat/long coordinates
2. Call Google places nearby API to get list of places within a 100m radius of the coordinates
3. Filter out any places that are obviously not relevant based on business name, place type, etc.
4. Call place details API for each remaining place to get address and google_maps_url
5. Scrape each google_maps_url to get Google business category for each place (like, "manufacturer" or "auto repair shop"). This is not an API call.
6. Filter out places based on Google business category
7. Resulting table is list of possible associated businesses for each original lat/long record
Appreciate any insight anyone might have. Thanks!
