Curbal has its own social media server on Mastodon. Check it out here!

Curbal

Learn how to grow your business with your data and Power BI

You are here: Home / Knowledge Base / How to do Pagination on a REST API in Power Query (Part 1) | List.Numbers
Welcome to our Knowledge Base

Tip: Start typing in the input box for immediate search results.

< All Topics
Print

How to do Pagination on a REST API in Power Query (Part 1) | List.Numbers

Posted
Updated
ByRuth Pozuelo Martinez

In today’s video, I am going to show you how to implement pagination when the number of pages or records to be returned are known.

Table of contents:

00:00 Intro
00:30 Not all APIs have the same structure
01:10 Get data from World Bank API
01:45 How pagination works on the API
02:30 Hardcode the number of pages
04:50 Dynamically feed the number of pages
06:06 Explain List.Numbers
08:20 Unknow number of records?

Watch the tutorial:

How to do Pagination on a REST API in Power Query (Part 1)

Links to the mentioned resources

And here is Part 2:

How to do Pagination without knowing the number of pages (Part 2) in Power Query | List.Generate
Was this helpful?

Reader Interactions

Let us know your thoughts...

Table of Contents