Forum Discussion
Automate skip and take for API call via power query
Hi, I have created a blank query, see below, to get data from a software API directly into power bi. Recently the software company put a restriction on the amount of data which can be requested ...
lbendlin
Super User
Super UserYou can write a recursive function that increments the skip count after each iteration. Just make sure you know when to stop (probably when the number of returned rows is less than the number of requested ("take") rows.