Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
12 | |
8 | |
8 | |
7 |
User | Count |
---|---|
15 | |
13 | |
7 | |
6 | |
5 |