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
Scenario: I’m looking to get data from the Workplace Graph API. Workplace is owned by Meta and the API allows for a subset of functionality of the Graph API from Facebook.
I was able to pull 25 records but I’m currently stuck at pagination to get more results.
Here’s the paginated results link from the documentation
Problem: I’m still very new to PQ advanced editor and M code so I’m not sure how to code the pagination using the documentation provided. For example, the maximum number of results we get back for members is 25 if I remove the limit.
Current Code:
let
#“BaseURL” = “https://graph.facebook.com/community/”,
#“limit” = 5,
Source = Json.Document(
Web.Contents(
#“BaseURL”,
[
RelativePath = “members”,
Query =
[
limit = Text.From(#‘limit’),
],
Headers=[
#“Authorization” = "Bearer " & #“Header”,
#“content-type” = “application/json”
]
]
)
)in
Source
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.