Using the Power Query Add-In - Microsoft Business Intelligence Tools for Excel Analysts - page 132

Click any step and the underlying M code appears in the Power Query formula bar.

If you don't see a formula bar in the Query Editor, click the View tab on the Query Editor
Ribbon, then place a check in the Formula Bar check box.

Tip

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, if you click
the step before the GroupedRows step, you see what the data looked like before you
applied grouping.

Tip

Managing query steps
You can right-click any step to see a menu of options for managing your query steps. Figure 7-9
shows 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 sub-
sequent 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.

Figure 7-9: Right-click any query step to edit, delete, or move the step.