Chapter 38: Introducing Power Query
38
When you click a query step, the data shown in the preview pane is a preview of what the data looked like up to and
including the step you clicked. For example, in Figure 38.11, clicking the step before the Removed Other Columns
step lets you see what the data looked like before you removed the nonessential columns.
You can right-click any step to see a menu of options for managing your query steps. Figure
38.12 illustrates the following options:Edit Settings Edit the arguments or parameters that define the selected step.
Rename Give the selected step a meaningful name.
Delete Remove the selected step. Be aware that removing a step can cause errors if subse-
quent steps depend on the deleted step.
Delete Until End Remove the selected step and all following steps.
Move Up Move the selected step up in the order of steps.
Move Down Move the selected step down in the order of steps.
Extract Previous Extract all steps prior to this one into a new query.FIGURE 38.12
Right-click any query step to edit, rename, delete, or move the step.