How to do Pagination on a REST API in Power Query (Part 1) | List.Numbers
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:

Links to the mentioned resources
And here is Part 2:

Was this helpful?
Reader Interactions