Applied steps in Power Query

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

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.

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

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.

Rename Applied steps-

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

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.

Refer more Power BI Post – Power BI

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