Forum Discussion

Devashish1's avatar
Devashish1
New Member
3 years ago

REST API - Automatically call the next page and append data in the table

I am trying to setup an API connection with Power BI desktop and facing an issue I need help with.

 

My API response has multiple pages and looks something like this - 

 

 

Each page has 20 results, and I have 403 results here. The 'next' parameter displays 'null' when there is no next page.

 

Can anyone please help me with the following  - A way to have all 403 results in one table?

 

Thanks in advance.