Home » Power BI » Applied steps in Power Query

Applied steps in Power Query

Applied steps list Power BI

In this blog you will understand about Applied Steps list in Power Query.

When you perform any transformations with your data it will show you in the Applied Steps list.

Applied Steps are very useful to track “Number of transformation with data”, and any time you can return the previous state to using applied steps.

Let’s get started-

Follow these steps to access the Applied Steps list-

Step-1: Go to Home Tab > Click on Transform Data

Transform data

Transform data

Step-2: Power Query Window appears, now click on View tab > Click on Query Settings, By default its enable, you can see applied steps in right side.

Access Applied Steps

Access Applied Steps



Step-3: If you change the column name, it will display in the Applied Steps list as Renamed Columns.

Applied steps list in Power Query

Applied steps list in Power Query

Step-4: In same way you can perform the other transformation, and all steps will be captured under applied steps list.

As you can see in below screenshot, here we performed some transformation like renamed columns, removed columns, filter rows, changed type & sort rows.

Applied steps list

Applied steps list



Rename Applied steps-

You can renamed the step based on transformation. To rename a step, right-click the step and select Rename.

Renamed applied steps

Renamed applied steps

Delete step( Return to Previous state)

If you want return previous state, just delete the steps. To delete a step, right-click the step and select Delete. Alternate way – Mouseover the steps and click on (x) icon.

Delete applied steps

Delete applied steps

Refer more Power BI Post – Power BI

Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome.



Leave a Reply