Chapter 14
Ten Tips for Working with Power Query
In This Chapter
Getting information from the Workbook Queries pane
Organizing queries
Referencing and duplicating queries
Configuring Power Query options
Boosting performance
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 Workbook Queries Pane
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 ...
Get Excel Power Pivot and Power Query For Dummies now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
