Power BI API Power Query

219 views Asked by At

this is the response from the api callHi I'm stuck with this problem, I am querying an API that only allows you to bring back 10 records at a time. Then you have to do another call and provide the next page key to get the next batch of 10 records and so forth. Is there a way for Power BI to use a variable to pull in the next page key from the response, and then use it in the API call to cycle through the data till the end of the data.

0

There are 0 answers