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.
Has anyone ever had issues with a paginated web API not pulling all available columns?
The company providing the data/API has confirmed the data is there, and I can also see it in the front end of the system.
Here is their documentation for this particular endpoint:
https://developers.samsara.com/reference/listdrivers
I used the same Advanced Editor query for all of the API endpoints.
let
url = "https://api.samsara.com/fleet/drivers",
Token = "#########################",
headers = [Headers=[ #"Authorization" = "Bearer " & Token ]],
FetchPage =
(url) as record =>
let
Source = Json.Document(Web.Contents(url,headers)),
data = try Source[data] otherwise null,
nextCursor = try if Source[pagination][endCursor] = "" then "DONE" else Source[pagination][endCursor] otherwise null,
res = [Data=data, NextPage=nextCursor]
in
res,
Drivers =
List.Combine(List.Generate(
()=>[res = FetchPage(url)],
each [res][NextPage]<> null,
each [res = FetchPage(url & "?after=" & [res][NextPage])],
each [res][Data]))
in
Drivers
Does anyone know why some of the columns wouldn't be showing up?
Hi @AmandaMulryan ,
You can refer to these documents and check if they can help:
Handling paging for Power Query connectors - Power Query | Microsoft Docs
powerbi - Paging REST API results in Power Query - Stack Overflow
powerbi - How to get paginated data from API in Power BI - Stack Overflow
How to do Pagination on a REST API in Power Query (Part 1) - YouTube
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
68 | |
64 | |
51 | |
39 | |
26 |
User | Count |
---|---|
84 | |
57 | |
45 | |
44 | |
35 |