Forum Discussion
Anonymous
3 years agoNot applicable
MS Graph ODatalink paging
Hey Folks, Looking for help to connect to Microsoft Graph and pull more than 999 records. Currently, below is working but not pulling all records Thanks (GraphURI as text) as recor...
ams1
3 years agoResponsive Resident
Hi,
The results are paged.
From https://learn.microsoft.com/en-us/graph/paging
If the result contains more results, Microsoft Graph will return an @odata.nextLink property...
If you look at the request response, you should see the next link there and you can use it to request the next page
I recently answered a question related to paging:
- https://community.powerbi.com/t5/Power-Query/how-to-iterate-the-data-of-several-sheets-of-a-web-page/m-p/3076115#M97845
- and also you can have a look at https://learn.microsoft.com/en-us/power-query/helper-functions#tablegeneratebypage
If this answer helped, please consider marking it as a solution.