Calling API in a blank query in Power BI dataflow

[Anonymous]

Hi Team - We are trying to fetch Ruleset/SoD data from an API in Power Query editor, the access to the API is granted through an Azure SPN. In one call, i can fetch a max of 500 records; whereas the total record count is much more than that. My question is how to call the API multiple times in a loop in power query editor, so that i can eradicate manual effort of calling the API again and again. I am very much new to Power Query and welcome to any sort of guidance and reference with this regard.

Thanks,

Dib

[mahoneypat · Accepted solution]

Please see this video with an example of how to do this.

Power BI - Tales From The Front - REST APIs - YouTube

Regards,

Pat

[v-yingjl · Accepted solution]

Hi @Anonymous ,

You can refer this viedo and simliar issue, hopes it could help.

1. Pagination and DO/WHILE in Power BI / Power Query 
2. how to create a query that paginates? 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mahoneypat · Accepted solution]

Please see this video with an example of how to do this.

Power BI - Tales From The Front - REST APIs - YouTube

Regards,

Pat