How to do Pagination without knowing the number of pages (Part 2) in Power Query | List.Generate
In today’s video, I am going to show you how to do pagination without knowing the number of pages that you need to paginate in the REST API and I will explain how list.generate works in Power Query.
Table of contents:
00:00 Intro
00:30 Create the function
02:20 Explain List.Generate
03:45 Implement List.Generate
06:50 Troubleshoot the query
Watch the tutorial:

Links to the mentioned resources
Here you can find part 1:

Was this helpful?
Reader Interactions