Timeout Google Maps API

[marimba]

Hello community,

I'm using the Google Maps Distance Matrix API to calculate the distance between two locations. I created a funcion for the API in the Query editor (following a Curbal tutorial), which I'm then calling from a table that has 2 columns, one for the origin and one for the destination addresses. The function works well and I obtain the distance between A and B without any problem. 

The problem comes when I try to apply the query. The dialogue box shows the message "waiting for maps.googleapis.com" and successively the number of added rows increases, but after a few minutes I get the error "OLE DB or ODBC error: [DataSource.Error] AnalysisServices: The connection either timed out or was lost.. api googlemaps". It seems that the addition of rows stops at around 1890 rows. I tried reducing my addresses table size to 1800 rows and then the query was applied without any problem. Any idea why am I not being able to apply the query when there is more than ca. 1800 rows? 

Thanks for you support!

[v-joesh-msft]

Hi @marimba ,

You can try the following methods:

1. Add a "timeout" parameter:

Go to query editor -right click your web data source - Advanced Editor. This will give you access to M code behind it. You need to specify "timeout" interval in there manually.

>>[timeout=#duration(0,0,30,0)]))

This is a TimeSpan like parameter, with the values representing Days, Hours, Minutes, Seconds.

2. Add a "max-results" parameter if possible

In addition, I will try to find someone who is familiar with this to take a further look at this. I will post back if we have any conclusions on this topic.

Best Regards,

Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.