OSRM - Sending an API single request with values from multiple rows

[stevemccall1]

Hi,

I'm working with a local OSRM instance to query a large amount of booking data to get travel time between the resouce location and destination.  This works fine with a small amount of data (around 1 week) but anything over a month takes a long time and usually ends in a timeout or failure.  I'm pretty sure the API is throttling / failing once it hits a certain number of requests.

I've been looking at the OSRM documentation and it appears there is a table service that allows you to send multiple pairs of coords in a single request.  I'm thinking this might be the way around it.  OSRM API Documentation (project-osrm.org)

It is possible to somehow make a call in this fashion from Power Query, that will be refreshable in the PowerBI service?  I don't really know where to start

[lolujubril]

One method is using the python and R integration in power query to wrangling the data using R or Python code. 

There's a package in R called osrm that has functions that make it easier