Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |