Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi,
I am trying to connect to the Graph API via Power Query and have built this logic to get all users from the /users endpoint
let
Data = let
Source = List.Generate( () => [WebCall = GetUsers()],
each Record.HasFields([WebCall], "@odata.nextLink"),
each [WebCall=Json.Document(Web.Contents([WebCall][#"@odata.nextLink"], [Headers = [Authorization = "Bearer " & Access_Token]]))],
each [WebCall]
),
#"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
in Source
in
Data
This is working fine except that I am missing some results and the table returned is always in multiples of 100, it seems that when the odata.nextLink field is not found, the current API call response is not appended to the list. What am I missing?
Thank you for your help!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
146 | |
85 | |
66 | |
52 | |
47 |
User | Count |
---|---|
215 | |
90 | |
83 | |
66 | |
58 |