Power QueryExercises

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

Related terms