The 2nd Edition of #25daysofdaxfridays challenge is here!
How can we help?

Welcome to Curbal Learning Portal. Search for answers using the search box below,
or create a request for a video or blog if you cannot find your answer.

Popular searches: DAX Glossary | Guided courses | Request a video

Print

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:

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

Links to the mentioned resources

Here you can find part 1:

How to do Pagination on a REST API in Power Query (Part 1)
Was this helpful?

Reader Interactions

Let us know your thoughts...

Table of Contents