Use incremental api as source

[Anonymous]

I am preparing a powerbi report for Service now. I need to get all the incidents data but the service now api returns only 10k records in a single call and I need to call service now api in below fashion from powerbi. How to do it. Please suggest.

In this case, the first call would be something like

/api/now/table/incident?sysparm_limit=10000&sysparm_offset=0

the next one

/api/now/table/incident?sysparm_limit=10000&sysparm_offset=10000

the next one

/api/now/table/incident?sysparm_limit=10000&sysparm_offset=20000

[v-alq-msft]

Hi, @Anonymous 

I'd like suggest you refer the following thread with the same issue to see if it helps.

Need help for Paging power query based on offset and limit 

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.