Applied steps
The ordered list of transformations in a query. Each step is a named M expression that usually takes the previous step as input, and the whole list reruns on every refresh.
Steps are evaluated lazily: when a later step needs a value, Power Query works back through the steps it depends on. Because each step refers to the previous one by name, inserting, deleting or renaming a step can break the steps after it. Keeping steps small and well named makes a query easy to review and debug.
In the Power Query editor
The Applied Steps pane on the right of the editor. Clicking a step shows the table at that point; the gear icon reopens the dialog that created it.
Learn more
Practise it
- beginner~7 minFree
Fix a query whose steps point at the wrong step (kite shop)
A step was renamed and the next step still refers to the old name. Repair the chain so the query runs.
- beginner~6 minFree
Remove a leftover step that cuts the data short (kite shop)
A Kept First Rows step left over from testing silently drops orders. Find it and remove it.
- beginner~5 minFree
Return the last step, not an earlier one (kite shop)
The query builds a Line Total column, but the result doesn't show it: the `in` clause returns an earlier step.
- beginner~6 minFree
Fix a Changed Type step that breaks two columns (kite shop)
An automatic type step turned customer names into errors and stripped the zeros from order numbers.