O'Reilly logo

Excel Power Pivot and Power Query For Dummies by Michael Alexander

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 14

Ten Tips for Working with Power Query

In This Chapter

arrow Getting information from the Workbook Queries pane

arrow Organizing queries

arrow Referencing and duplicating queries

arrow Configuring Power Query options

arrow 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required