0

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.

mr biggs
  • 1
  • 1
  • 1
    Can you show us your REST call? Why does the API limit you to 10? The best solution is unlikely to involve looping through batches of 10 at a time, especially to populate a Power BI dataset. – TDP Dec 03 '20 at 09:33
  • the API was designed that way by the vendor. this is the response of the call i have attached the response of the call in the hyperlink in my question above this is the api call that i make https://dynamon.server5.bina.net/e/4396-a544-c9ced0861299/api/v2/problems?fields=impactAnalysis – mr biggs Dec 04 '20 at 06:43
  • You need to create a loop with a function, here more details: https://medium.com/@marktiedemann/how-to-do-pagination-in-power-query-430460c17c78 – Angelo Canepa Dec 04 '20 at 13:02

0 Answers0