Multiple scripted queries to API

[Lemming]

Hi All, Noob PowerBI user here.. 

I have a web hosted API to query collect some measurements. I can get to query to return data, but the API has some limitations. It will only allow 1000 values per page, and if the data exceeds this will insert a field with a query to get the next page with 1000 values and so on.

Can I set a script to send the initial query, get the data, then keep sending depending on whether the next query is present in the returned data ? 

I may be using incorrect terminology, but if its a "can do" and there is an example / guide somewhere would be appreciated.

[Lemming]

Will do, thanks foirthe help

[lbendlin · Accepted solution]

Search for "Power BI API Paging"

Handling paging for Power Query connectors - Power Query | Microsoft Learn

[Lemming]

Thanks for the pointer. Reading the description, exactly what i need.. Unfortunately, the helper assumes you know something about M language lol.. More reading / googling for me..