How to get more than 1000 items from Orchestrator API in Power BI?

Hi everyone,

I have to create a dashboard in Power BI. I have connect PowerBI to orchestrator through the API. But the issue is that with a normal query to Queue Items, the maximum number I get is 1000. I would need to get all the items that are currently in the queues, to build a dashboard with an viewing history.

Can anyone help me to get this?

@ajgb

you need to perform the query with pagination using skip

cheers

how do I do that in power query? I mean, i know that solution and is what I use in studio to get more than 1000 items, and then merging tables. But in Power Bi? how do I put that filters?

@ajgb

please check this

cheers