Chapter 14
Ten Tips for Working with Power Query
IN THIS CHAPTER
Getting information from the Queries & Connections pane
Organizing queries
Referencing and duplicating queries
Configuring Power Query options
Viewing query dependencies
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.
Getting Quick Information from the Queries & Connections Pane
All the Power Query queries that live in a particular workbook can be viewed in the Queries & Connections pane. Choose Data ⇒ Show Queries to activate the Queries & Connections pane.
In this pane, you can see some quick information about a query ...