How to See Applied Steps in Power BI

One of Power BI's most useful features for cleaning and shaping your data is tucked away in plain sight: the Applied Steps pane. This history log tracks every single transformation you make, giving you an amazing ability to review, edit, and debug your entire cleanup process. This article will show you exactly how to find, interpret, and use the Applied Steps pane to build better, more reliable reports.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What Exactly Are "Applied Steps" in Power BI?

Think of the Applied Steps pane as a recipe for your data. Every time you perform an action in the Power Query Editor - Power BI's tool for data transformation - it records that action as a specific "step" in a list. This list isn't just a simple history, it's an interactive and editable log of your entire data preparation workflow for a specific query. It's like the version history in a Google Doc or the undo history in a design program, but purpose-built for data. Whenever you connect to a data source, Power BI automatically creates the first few steps, like connecting to the source and navigating to the specific table. From there, every single change is added to this list. The Applied Steps pane tracks actions such as:

• Removing columns or rows
• Filtering data based on specific criteria
• Changing data types (e.g., from Text to a Date)
• Replacing values
• Pivoting or unpivoting columns
• Merging or appending queries
• Adding custom or conditional columns

So, why is this so important? This feature is the foundation of clean and repeatable data models. It ensures that every time you refresh your data, the exact same sequence of cleaning and transformation steps is applied automatically. It also acts as a built-in documentation and debugging tool, allowing you or a teammate to instantly understand how the raw data was shaped into its final, report-ready form.

How to Find the Applied Steps Pane

If you've ever cleaned data in Power BI, you've almost certainly seen this feature without realizing how powerful it is. Locating it is simple, as it lives inside the Power Query Editor. Here’s how to get there.

Step 1: Open the Power Query Editor

From your main Power BI Desktop window, go to the Home tab on the ribbon at the top of the screen. Look for the "Queries" section and click the Transform data button. This will launch the Power Query Editor in a new window, which is where all the data shaping magic happens.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 2: Locate the Pane

Once you're in the Power Query Editor, select any of your queries from the left-hand pane. Now, look to the right side of the screen. By default, you’ll see the Query Settings pane. The Applied Steps list is the main component of this section, right below the field for the query's name. Is the pane missing? If for some reason you don’t see the Query Settings pane, don't worry. Just go to the View tab in the Power Query Editor's ribbon and make sure that the Query Settings checkbox is ticked. This will make the pane reappear immediately.

How to Work with Applied Steps

Just viewing the list of steps is helpful, but the real power comes from interacting with it. You can navigate through them, rename them for clarity, reorder them, and even edit their settings without having to start over. Let's walk through how to manage your applied steps effectively.

Navigate Through Your Transformation History

Each item in the Applied Steps list is clickable. When you click on a specific step, the main data preview window will update to show you what your data looked like after that step was applied. This is an incredibly powerful debugging feature. For example, if you notice a column has incorrect values in the final step, you can click back through the previous steps one by one. The moment the incorrect values appear, you've pinpointed the exact transformation that caused the issue. You can see the "before" state (the step just prior) and the "after" state (the step where the problem occurs).

Rename Steps for Better Documentation

Power BI gives generic names to most steps, such as "Filtered Rows," "Renamed Columns," or "Added Custom." While functional, these names aren't very descriptive if you have several of them. To make your process understandable at a glance, you should rename your steps. To rename a step, simply right-click on it and select Rename. For example:

• "Filtered Rows" could become "Removed Inactive User Accounts."
• "Renamed Columns1" could be changed to "Standardized Column Header Names."
• "Replaced Value" can be updated to "Corrected State Abbreviation for NY."

This simple practice transforms your Applied Steps list into a step-by-step narration of your data cleaning process, making it much easier for you to maintain in the future or for a colleague to take over.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Editing a Step's Settings

What if you filtered your data but now need to adjust the criteria? You don't have to delete the step and re-do it. Many steps have a small gear icon (⚙️) next to their name. Clicking this icon will reopen the dialogue window you used to create the step in the first place. For a "Filtered Rows" step, clicking the gear icon will bring back the filter options, allowing you to change the values or logic. For a "Change Type" step, it will let you select a different data type. This is the non-destructive way to tweak and refine your transformations as your needs change.

Deleting Steps to Undo Mistakes

If you need to undo a transformation completely, just find the corresponding step and click the red "X" icon next to its name. Power BI will ask for confirmation because this action can't be undone easily and might break subsequent steps. For instance, if you remove a column in Step 3 and then try to rename that same column in Step 5, deleting Step 3 will cause an error in Step 5 because the column it's looking for no longer exists. Be mindful of these dependencies when deleting steps from the middle of your list.

Reordering Steps (Use with Caution)

You can also change the sequence of operations by dragging and dropping steps in the list. This can sometimes help optimize query performance or fix an ordering issue. However, you should be extremely careful when doing this. As with deleting steps, changing the order can break your query if a later step depends on an action from an earlier step. Always re-select the final step after reordering to confirm that your query still works and produces the expected output.

Advanced Techniques with Applied Steps

Once you are comfortable with the basics, you can use the Applied Steps functionality for more advanced data shaping and workflow management.

View the Underlying M Code

Every click you make in the Power Query Editor generates a script in a language called Power Query M. Your "Applied Steps" is a user-friendly view of this underlying code. To see it, go to the Home tab and click on the Advanced Editor. The Advanced Editor window shows you the complete M code for your query. You’ll notice that each of your (hopefully well-named) applied steps corresponds to a line of code. Seeing how the UI actions translate into M code is a fantastic way to learn the language and empower you to write or debug queries manually when needed.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Insert an Intermediate Step

Sometimes you need to add a transformation right in the middle of your existing process. To do this, simply select the step in the list that you want your new step to come after. Then, perform your new transformation (e.g., remove a column, replace a value). Power BI will show a warning asking if you are sure you want to insert a step at this point. If you confirm, the new step will be added to the sequence. Once again, it's crucial to click on the very last step in your list to ensure this insertion hasn't caused errors in any of the subsequent steps.

Branching Your Queries with "Extract Previous"

This is an incredibly useful technique for staying organized. Imagine you've performed 10 steps to connect, clean, and standardize your base sales data. Now, you need to create three different reports from this cleaned data - one grouped by region, one by product, and one by salesperson. Instead of duplicating all those 10 cleaning steps for each of the three reports, you can do the following:

1. On your primary query, right-click on the last cleaning step (before you start the specific grouping/summarization).
2. Select Extract Previous.
3. Give this new query a name, like "Cleaned Salesforce Data - Base."

This creates a completely new query that stops at the point you selected. Now you can build your three specific reports by referencing this clean base query, rather than starting from the raw source each time. If you ever need to update a cleaning rule, you only have to do it once - in your base query - and the changes will automatically flow down to all dependent queries.

Final Thoughts

Mastering the Applied Steps pane in Power BI transforms you from a casual user into an efficient data practitioner. It's the central hub for ensuring your data preparation is transparent, repeatable, and easy to debug. By taking the time to review your steps, rename them for clarity, and use them to trace your workflow, you build a solid foundation for trustworthy and maintainable reports. While Power BI's tools are powerful for deep analysis, creating each step manually can still be time-consuming when you just need a fast answer. That's why we built Graphed to bypass the manual data prep entirely. Instead of clicking through menus to transform data and build reports, you can describe what you need in plain English. Graphed connects directly to your marketing and sales platforms and instantly generates the dashboard, handling all the complex transformations on your behalf and freeing you up to act on insights instead of just preparing them.