Pagination and DO/WHILE in Power BI / Power Query

Note June 2021: It appears that some of the links used in this video are no longer working or are giving results different than the ones showcased in this video. Sadly, this is the nature of the web and I have no control over it. Nevertheless, the concepts showcased in this video are still valid and very much true for creating any sort of pagination solution with Power Query.
If you wish to learn more about Pagination with Power Query, be sure to check out the official documentation from the Power Query team from the link below:
docs.microsoft...
Matt's original blog post (link appears to be broken): www.mattmasson...
Box Office mojo link (the website appears to have changed):
www.boxofficemo...
Other videos about the List.Generate function:
• Future Monthly Salary ...
• BULK Replace Values in...