topic Re: Azure Active Directory API 1000 row batchs in Developer

Azure Active Directory API 1000 row batchs

Jmcgrath — Sun, 25 Feb 2018 04:04:17 GMT

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?

Re: Azure Active Directory API 1000 row batchs

v-ljerr-msft — Mon, 26 Feb 2018 08:35:58 GMT

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

Re: Azure Active Directory API 1000 row batchs

Jmcgrath — Tue, 27 Feb 2018 12:58:26 GMT

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.

Re: Azure Active Directory API 1000 row batchs

Jmcgrath — Tue, 27 Feb 2018 18:10:42 GMT

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