Powerquery will sometimes stop in middle of an API call

[Eric Landry]

Hi,

I've set up a Powerquery function to make API calls. The input is a table with about 3000 tickers it feeds to a data provider. The provider then returns several fields of fundamental data. The problem I'm having is that often Powerquery will stop in the middle of a job, then close and load the data it's fetched to that point. The point at which it stops is random, with the only consistency being a blank row at the bottom of the table. It could be row 100, 206, 1005, 2540, or any other row.

Could it be that it's hitting some sort of a timeout at the website that's causing it to stop and load every time this happens? I really have no idea why this otherwise very cool and productive tool is doing this.

Any help would be greatly appreciated!

Thanks

 

[Ken Puls]

Hi Eric,

That's quite possible, yes. Have a look at this post from Chris Webb and see if it helps any: https://blog.crossjoin.co.uk/2014/11/14/waiting-between-web-service-requests-in-power-query/

 

[Eric Landry]

Thanks Ken!