What are Applied Steps in Power BI?

If you've spent any time working with data in Power BI, you've likely seen the “Applied Steps” pane in the Power Query Editor. It's the little box on the right side of your screen that automatically records everything you do. This article will show you why it isn't just a simple history list, but one of the most powerful and time-saving features in Power BI.

Graphed

Still Building Reports Manually?

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

Watch the Demo

We'll walk through what Applied Steps are, how to work with them, and how they can make your data preparation process cleaner, more reliable, and much easier to troubleshoot.

What Exactly Are Applied Steps in Power BI?

Each time you import data into Power BI, you're almost always going to need to clean and prepare it before building visuals. This process, often called data transformation, happens in the Power Query Editor. Applied Steps are the saved, sequential record of every single transformation you perform.

Think of it like a recipe for your data. When you first bring in your raw ingredients (your original data table), Power BI starts writing down the instructions:

• Removed the "Notes" column.
• Filtered out all rows where the region wasn't "North America."
• Changed the "Order_Date" column from text to a proper date format.
• Renamed the "salesID" column to "Sales ID."

This "recipe" is your list of Applied Steps. Every click you make in the Power Query Editor - filtering, removing columns, splitting text, pivoting data - is automatically recorded as a distinct, legible step. You can find this list on the right side of the screen inside the Power Query Editor, under the "Query Settings" pane.

The beauty is that this isn't just a log for your reference. It's a living, repeatable set of instructions that Power BI follows every time you refresh your data, ensuring your report always uses data prepared in the exact same way.

Why Applied Steps Are Your Data Prep Superpower

Manually cleaning data in spreadsheets every week is a tedious and error-prone chore. This is where Applied Steps move from being a neat feature to a non-negotiable part of a solid data workflow. Here are the main reasons they are so valuable.

Graphed

Still Building Reports Manually?

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

Watch the Demo

1. Completely Automated Repeatability

This is the big one. Imagine you connect to a sales data CSV that gets updated daily. Every Monday, using Excel, you would have to download the new file and repeat the same 12 cleaning steps - deleting columns, filtering for specific products, creating a new calculated column. It takes time, and you risk making a mistake.

With Applied Steps in Power BI, you do it once. You build your "recipe" of transformations one time, and Power BI saves it. The next time you hit "Refresh," Power BI grabs the new file and automatically runs through every single one of those saved steps in order. Hours of manual work every week turn into a single button click.

2. Total Transparency and an Audit Trail

Have you ever inherited a spreadsheet and wondered, "How on earth did they arrive at this number?" With Applied Steps, that confusion disappears. You have a full, step-by-step account of exactly how the raw data was transformed into the final clean version. Anyone on your team can open the query, read through the steps, and understand the entire data preparation journey. It provides a clear, built-in audit trail for your data logic.

3. Effortless Debugging and Troubleshooting

Sooner or later, a data refresh will fail, or a visual will look strange. Without Applied Steps, you’d be stuck frantically searching through a massive dataset for the problem. With them, debugging becomes incredibly straightforward.

You can literally click on each step one by one, starting from the original source. As you click down the list, the data preview shows you what the table looked like at that exact stage. You can easily spot the step where something went wrong - maybe a column name changed in the source data causing a "Renamed Column" step to fail, or a new text value appeared in a number column, breaking a "Changed Type" step.

Graphed

Still Building Reports Manually?

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

Watch the Demo

4. Ultimate Flexibility and Modifications

Your "recipe" is not set in stone. The Applied Steps feature is designed to be completely flexible. You can:

• Edit a step: Did you filter for the wrong region? No need to start over. Just click the gear icon next to the "Filtered Rows" step and change the criteria.
• Delete a step: Decided you actually need a column you removed earlier? Find the "Removed Columns" step and click the "X" to delete it.
• Reorder steps: Simply drag and drop steps to change the order of operations. This can be crucial for an efficient and error-free query.

A Practical Walkthrough: Working with Applied Steps

Let's move from theory to practice. Here is a simple, common scenario to show you how Applied Steps work in the wild.

Step 1: Get into the Power Query Editor

First, we need to load some data. In Power BI Desktop, click on "Get data" and connect to your source (an Excel file, a CSV, etc.). Once the data is loaded into the navigator, don't click "Load." Instead, click "Transform Data." This takes you into the Power Query Editor, which is the command center for data preparation.

Step 2: Start Making Some Transformations

As soon as your data loads, you'll see a few steps already in the list, like "Source" and "Navigation." These are just Power BI recording where it got the data from. Now, let’s perform a few cleaning actions.

Imagine our sales data table looks something like this:

order_id, customerName, product-name, revenue, sale_date, notes

The column headers aren't great, the date is text, and we have an unnecessary notes column.

Action 1: Remove the Notes Column We don't need the notes column for our analysis. Right-click on the "notes" column header and select "Remove."

Look at your Applied Steps pane. A new step named "Removed Columns" has appeared.

Action 2: Change the Data Type for Sale Date The sale_date column is formatted as text. Click the little "ABC" icon in the column header and select "Date."

Again, a new step pops up: "Changed Type." It's that simple. Power BI diligently records every move.

Action 3: Rename Columns for Better Readability Double-click on the customerName header and rename it to "Customer Name". Do the same for product-name turning it into "Product Name".

You’ll see a step called "Renamed Columns" appear. Power BI often groups similar actions into a single step for efficiency.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Managing and Editing Your Applied Steps

Now that you've built a small sequence of steps, you need to know how to manage them. This is where you can refine, correct, and optimize your data transformation process.

How to View, Edit, and Rename a Step

• Select a Step: To see what your data looked like at a certain point, just click on the name of the step in the list. This is your debugging time machine.
• Edit a Step (the gear icon): Some steps, like "Filter Rows," have a small gear icon (⚙️) next to them. Clicking this opens the dialog box for that action, allowing you to change the parameters. For instance, you could change your filter from "USA" to "Canada" without having to delete and recreate the step.
• Rename a Step: Power BI's default step names ("Changed Type," "Filtered Rows") are useful but can be vague. If you have multiple filtering steps, things get confusing. Right-click on any step and choose "Rename." Change "Filtered Rows" to something descriptive like "Filtered for Active Subscriptions." This makes your query logic much easier to understand for colleagues (or for yourself six months from now).

How to Reorder and Delete Steps

• Reorder Steps: You can drag and drop steps in the list to change their execution order. A word of caution: this can sometimes break your query. Changing the order is only safe if the steps are independent of each other.
• Delete a Step: To undo an action, click the red "X" next to the step name you want to remove. A warning will pop up, cautioning that deleting a step may affect subsequent steps and could break the query. For example, if you rename a column in step 3 and then delete that step, any later step that relies on that new column name will error out. It’s best to delete steps from the bottom up.

Going Deeper: Behind the Scenes with M Code

The Applied Steps list is actually a simple, user-friendly interface for Power BI's underlying data transformation language, called M code.

To see this, go to the "View" tab in the Power Query Editor and click "Advanced Editor." A new window will open showing the code that Power BI generated as you clicked around. Each step you performed corresponds to a line of code. Renaming a step in the Applied Steps pane even changes the variable name in the M code.

You don't need to learn M to be proficient with Power Query. But as you get more advanced, knowing that you can directly edit this code to perform complex transformations not available in the user interface is an incredibly powerful option to have.

Final Thoughts

Mastering Applied Steps turns a potentially chaotic data preparation process into an orderly, transparent, and repeatable workflow. By understanding how to manage this sequence of transformations, you can save countless hours, troubleshoot errors efficiently, and build truly robust and reliable reports in Power BI.

Of course, this is just the beginning. The learning curve for tools like Power BI can be steep, even for simple tasks involving different data platforms. That weekly routine of downloading CSVs and preparing reports still has hidden friction points. This is why we built Graphed to simplify the entire process. We connect directly to your marketing and sales tools like Google Analytics, Shopify, and Facebook Ads, automatically syncing your data in one place. Instead of building out Applied Steps by hand, you can just tell Graphed what you want in plain English, and it instantly builds real-time, shareable dashboards for you.