Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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!
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 66 | |
| 44 | |
| 40 | |
| 29 | |
| 19 |
| User | Count |
|---|---|
| 200 | |
| 126 | |
| 103 | |
| 70 | |
| 54 |