Accessing matrix service with Power Query

[amandus]

Hi @bkolodziejczyk,

Probably try the approach used here:

Using Power Query: Returning Error 429

Hi, I’m using Power Query to get distance and travel time between data points. I’m now running into the issue of Error 429 being returned, which, if I’ve read correctly, is the error returned when too many requests/sec are made. I’m unaware of any way of throttling Power Query (at this stage anyway) but, I need to ask if there is any way to workaround this error. For those that may be interested, below is the M code for an API request to extract the travel time and distance. let Coordinate…

Instead of using Json.FromValue.

Best regards