In This Chapter
Getting information from the Workbook Queries pane
Referencing and duplicating queries
Configuring Power Query options
Over the past few years, Microsoft has added countless features to Power Query. It has truly become a rich tool set with multiple ways to perform virtually any action you can think of. This growth in functionality has paved the way to a good number of tips and tricks that can help you work more efficiently with your Power Query models.
This chapter presents ten of the more useful tips and tricks you can leverage to get the most out of Power Query.
All the Power Query queries that live in a particular workbook can be views in the Workbook Queries pane. Choose Data ⇒ Show Queries to activate the Workbook Queries pane.
In this pane, you can see some quick information about a query by simply hovering the ...