It took three entries for Power Query to catch up with the pattern. In this basic example, you don’t gain much; however, if you have dozens or even thousands of records, this feature comes in handy.

In this tutorial, I’ll show you how to use Power Query to generate a list of sheet names that you can then load into Excel and use to navigate the workbook.

Learn Power BI basics in this beginner tutorial. Master the interface, connect data sources, clean data, and build your first data model.