Part V: Understanding Power Pivot and Power Query
FIGURE 41.6
Create a new query from an existing column.
Copying queries to save time
It’s always smart to reuse work whenever you can. Why reinvent the wheel when your
Queries & Connections pane is full of wheels that you’ve already created?
Save time by duplicating the queries in your workbook. To do so, activate the Queries &
Connections pane, right-click the query you want to copy, and then select Duplicate.
Setting a default load behavior
If you’re working heavily with Power Pivot as well as Power Query, chances are that you’re
loading your Power Query queries to the internal data model a majority of the time. If
you’re one of those analysts who always loads to the data model, you can tweak the Power
Query options to load to the data model automatically.
Click Data ➪ Get Data ➪ Query Options to open the dialog box shown in Figure 41.7. Select
Data Load under Global and then choose to specify a custom default load setting. This
enables the options to load to the worksheet or load to the data model by default.
