Calling API in a blank query in Power BI dataflow

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