Forum Discussion

stevemccall1's avatar
stevemccall1
Frequent Visitor
3 years ago

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

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

Need Help

1 Reply

  • lolujubril's avatar
    lolujubril
    New Member
    2 years ago

    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