Part V: Understanding Power Pivot and Power Query
Rename Rename the selected query.
Refresh Refresh the data in the selected query.
Load To Open the Load To dialog box, where you can redefine where the selected query’s
results are used.
Duplicate Create a copy of the query.
Reference Create a new query that references the output of the original query.
Merge Merge the selected query with another query in the workbook by matching speci-
fied columns.
Append Append the results of another query in the workbook to the selected query.
Send To Data Catalog Publish and share the selected query via a Power BI server that
your IT department sets up and manages.
Export Connection File Save an Office Data Connection (.odc) file with the connection
credentials for the query’s source data.
Move To Group Move the selected query into a logical group that you create for better
organization.
Move Up Move the selected query up in the Queries & Connections pane.
Move Down Move the selected query down in the Queries & Connections pane.
Show the Peek Show a preview of the query results for the selected query.
Properties Rename the query and add a friendly description.
The Queries & Connections pane is especially useful when your workbook contains several
queries. Think of it as a kind of table of contents that allows you to easily find and interact
with the queries in your workbook.
Understanding column-level actions
Right-clicking a column in the Power Query Editor activates a shortcut menu that shows a
full list of the actions you can take. You can also apply certain actions to multiple columns
at one time by selecting two or more columns before right-clicking. Figure 38.14 shows the
available column-level actions, and Table 38.1 explains them, as well as a few other actions
that are available only in the Power Query Editor Ribbon.
Note that all the column-level actions available in Power Query are also available in the Power Query Editor Ribbon.
Thus, you can either opt for the convenience of right-clicking to select an action quickly or choose to utilize the more
visual Ribbon menu. There are a few useful column-level actions found only in the Ribbon (see Table 38.1).
