Solved: Azure Active Directory API 1000 row batchs

Jmcgrath · ‎02-24-2018

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 · ‎02-26-2018

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

View solution in original post

v-ljerr-msft · ‎02-26-2018

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 · ‎02-27-2018

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.