Azure Active Directory API 1000 row batchs

[Jmcgrath]

Looking for help on this topic in regards to Active Directory API.

This call returns the data in batches. Each batch has a maximum of 1000 records.
To get the next batch of records, use the Next link. Get the skiptoken information from the first set of returned records. The skip token will be at the end of the result set.

Can anyone provide an example of using this skiptoken?

[v-ljerr-msft · Accepted solution]

Hi @Jmcgrath,

Here is a good article about how to load paged and related data from MS Graph API into Power BI using a recursive Power Query function, a solution which makes use of the skiptoken is mentioned. Could you go to check if it helps in your scenario? 

Regards

[Jmcgrath]

Thanks for the help.  This article suggests a work around instead of $skiptoken which I have implemented and appears to work.  Thanks again.  At least buys me time until I learn more about $skiptoken utilization.

[Jmcgrath]

Only problem solution link provides uses a function which is not supported in Power Bi for report refresh