Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi
I have managed to retrieve the data from this Graph API request
GET https://graph.microsoft.com/v1.0/users
i got the data but they are not complete at all, i have only one third of my data.
could you please tell me how to get the comprehensive data?
thanks
Solved! Go to Solution.
Hi, @Anonymous
This is happening because Graph API from MS returns paginated results. So, to retrieve all pages from the result, you can try M code in PQ
for example,
let
GetAllPages = (url as text) as list =>
let
Source = Json.Document(Web.Contents(url)),
data = Source[value],
next = try Source[@odata.nextLink] otherwise null,
output = if next is null then data else List.Combine({data, @GetAllPages(next)})
in
output,
InitialUrl = "https://graph.microsoft.com/v1.0/users",
Data = GetAllPages(InitialUrl)
in
Data
Note: Power BI's Power Query component has a limit to the number of recursions it can perform, so if you have a very large number of pages, you may need to adjust the recursion limit in the options.
You would also need to include an 'Authorization' header with your access token in the Web.Contents function, and you'll need to handle any rate limits or other API constraints from the Graph API. As this example stands, it's a very basic example and would need to be expanded to handle a production use case.
Proud to be a Super User!
Hi, @Anonymous
This is happening because Graph API from MS returns paginated results. So, to retrieve all pages from the result, you can try M code in PQ
for example,
let
GetAllPages = (url as text) as list =>
let
Source = Json.Document(Web.Contents(url)),
data = Source[value],
next = try Source[@odata.nextLink] otherwise null,
output = if next is null then data else List.Combine({data, @GetAllPages(next)})
in
output,
InitialUrl = "https://graph.microsoft.com/v1.0/users",
Data = GetAllPages(InitialUrl)
in
Data
Note: Power BI's Power Query component has a limit to the number of recursions it can perform, so if you have a very large number of pages, you may need to adjust the recursion limit in the options.
You would also need to include an 'Authorization' header with your access token in the Web.Contents function, and you'll need to handle any rate limits or other API constraints from the Graph API. As this example stands, it's a very basic example and would need to be expanded to handle a production use case.
Proud to be a Super User!