What is Applied Steps in Power Query?

< 1 min read

Applied Steps in Power Query are the sequential transformations recorded on a dataset.
Each action like filter, rename, trim, or type change is tracked as a step.
In my project, we first removed nulls, then renamed columns, then merged tables.
Steps appear in the Applied Steps pane and can be edited, reordered, or deleted.
They are applied in sequence every time the query refreshes.
Power Query generates M code behind the scenes for all steps.
It allows easy auditing and debugging of the transformation process.
Reordering steps can fix issues like query folding breaks.
Steps are automatically replayed during scheduled refresh in Power BI Service.
So Applied Steps provide a clear, repeatable record of all data transformations.

Power BI Essentials