Forum Discussion

Lemming's avatar
Lemming
New Member
2 years ago
Solved

Multiple scripted queries to API

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.