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
I'm importing JSON data via an API which has multiple pages due to the amount of data. I can import 1 page fine, however I'm not sure how to configure this for multiple pages.
The format for pulling information to a JSON file is something like this:
https://site.com/api/v1/xxxx/?limit=1000&page=1&include=id,name
Where I would change the page # to 2 then to page 3 etc.
Solved! Go to Solution.
@jtpiazzamn , refer if this can help
https://medium.com/@marktiedemann/how-to-do-pagination-in-power-query-430460c17c78
@jtpiazzamn , refer if this can help
https://medium.com/@marktiedemann/how-to-do-pagination-in-power-query-430460c17c78
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 61 | |
| 43 | |
| 40 | |
| 38 | |
| 22 |
| User | Count |
|---|---|
| 178 | |
| 124 | |
| 116 | |
| 77 | |
| 54 |