How to Remove Pending Query Changes in Power BI

Nothing stops a Power BI workflow faster than a cryptic message. You've been shaping your data, removing columns, filtering rows, and suddenly a persistent banner appears: "You have pending changes in your queries that haven't been applied." While it's tempting to feel like you've broken something, this is actually a normal part of the process. This article will show you exactly what this message means and how to confidently remove those pending changes when you need to.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What Exactly Are "Pending Query Changes"?

Think of Power BI's Power Query Editor as a workshop for your data. Every time you perform an action - like changing a column's data type from text to a number, removing a column you don't need, or filtering out certain rows - you're creating a set of instructions for Power BI to follow. Each instruction is a "step."

The "pending changes" message is simply Power BI's way of telling you, "Hey, you've written down some new instructions in the workshop, but I haven't carried them out on the main dataset yet."

Your visuals, reports, and dashboards in the main Power BI window won't reflect these new transformations until they are "applied." This separation is intentional. It allows you to perform multiple transformations at once and then load the clean, final dataset in a single, efficient step, rather than reloading your entire dataset after every tiny change. The message appears because there's a difference between the data analyzed in the Power Query Editor and the data currently loaded into the Power BI data model that fuels your reports.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Common Actions that Create Pending Changes

You'll see this notification pop up after performing almost any data transformation task in the Power Query Editor, including a few of the most frequent ones:

• Removing columns or rows
• Renaming columns
• Changing a data type (e.g., Text to Date)
• Merging or appending queries
• Splitting columns
• Adding a custom or conditional column
• Pivoting or unpivoting data

The Standard Fix: Applying Your Changes

In most situations, your goal isn't to remove the changes but to apply them. You've cleaned the data and you want your report to reflect that hard work. Applying is the intended, default action you'll take 99% of the time.

Here's how to do it:

• Step 1: In the Power Query Editor, you'll see a yellow banner at the top of your screen with the message.
• Step 2: In that banner, you will find a button labeled "Apply changes." Alternatively, you can go to the "Home" tab in the ribbon at the top of the editor and click the "Close & Apply" button.

Once you click it, Power BI will close the editor and a new window will appear, showing the data being loaded and processed. This might take a few seconds or a few minutes, depending on the size of your dataset and the complexity of your transformations. When it's done, your reports and visuals will automatically update to reflect the newly structured data.

When Should You Remove (or Discard) Pending Changes?

So if applying changes is the standard procedure, why would you ever want to remove them? The need to discard changes usually comes down to one of these common scenarios:

• You made a mistake: You accidentally removed a critical column, applied a filter that wiped out too much data, or botched a merge. Instead of trying to untangle the mistake, it's easier to just start over from the last saved state.
• You were just experimenting: Sometimes you want to test out a specific transformation to see how it affects your data without committing to it. You might duplicate a column and try a few changes, ultimately deciding they aren't useful.
• Your change broke the query: A particular change might have introduced an error that prevents the query from loading at all. The entire query might show an error icon, and the easiest fix is often to undo the step that caused it.
• The new steps are harming performance: A complex merge or a computationally intensive custom column might be slowing your data refresh to a crawl. You might want to remove it to find a more efficient way to get your desired result.

In these cases, applying the changes is the last thing you want to do. Instead, you need a way to tell Power BI, "Never mind, forget what I just did."

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

How to Remove All Pending Query Changes at Once

If you've made a series of changes that you want to undo completely, the fastest method is using the "Discard Changes" function. This is your "Ctrl+Z" for the entire session in a Query Editor.

Method 1: Using "Discard Changes"

This approach wipes out all unapplied changes across all your queries. It's a full reset back to the last time you applied changes.

• Step 1: Open the Power Query Editor If you aren't already there, go to the "Home" tab of the main Power BI window and click "Transform data."
• Step 2: Find the "Close & Apply" Button On the "Home" tab of the Power Query Editor ribbon, locate the "Close & Apply" button. But don't click the main button itself - click the small dropdown arrow attached to it.
• Step 3: Select "Discard changes" From the dropdown menu, choose the option labeled "Discard changes."

Power BI will likely show a confirmation pop-up asking if you are sure you want to discard your changes. Click yes. The Power Query Editor will close, and you will be returned to the main Power BI window. All your experimental or incorrect transformations will be gone, just as if you never made them.

How to Remove Specific Pending Changes

Sometimes the "all-or-nothing" approach is too drastic. You might have made ten modifications, but only the very last one was a mistake. In this case, you don't want to throw away all your work, just the incorrect step. This is where the "Applied Steps" pane becomes your best friend.

Method 2: Using the "Applied Steps" Pane

The Applied Steps pane, typically located on the right side of the Power Query Editor, keeps a running log of every single transformation you've made to a selected query. Each action is listed chronologically, allowing you to go back in time and remove steps one by one.

• Step 1: Select the Query You Want to Edit In the "Queries" pane on the left side of the Power Query Editor, click on the specific query that contains the changes you want to revert.
• Step 2: Locate the "Applied Steps" Pane Look to the right side of your screen. You will see a list of actions under the "Applied Steps" heading. The top step is the "Source" (where your data came from), and every subsequent step represents a transformation you've made.
• Step 3: Delete the Unwanted Step(s) To remove a step, simply hover over it and click the red "X" icon that appears to its left. Let's say your last two steps were "Renamed Columns" and then "Filtered Rows," but you realize the filtering was incorrect.
• Click the "X" next to "Filtered Rows." That specific action will be instantly undone.

You can continue clicking the "X" on steps to move further back in your process. It’s generally safest to remove steps in reverse order, starting from the most recent one. If you try to delete a step from the middle of the list, Power BI will warn you that this could break the steps that came after it, as they often depend on each other. However, for undoing a recent mistake, it’s the perfect tool.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Which Method Is Right for You?

• Use "Discard Changes" when you want a quick, total reset. It's for moments when you've gone down the wrong path and need to revert to your last good state.
• Use the "Applied Steps" pane when you need surgical precision. It's best for catching a single mistake while preserving all the other valid transformations you've just made.

A Few Best Practices for Safer Data Transformation

To minimize future headaches and make undoing work easier, adopt a few simple habits in your Power BI workflow:

1. Name Your Steps: By default, steps get generic names like "Filtered Rows" or "Changed Type." You can right-click any step and select "Rename" to give it a more descriptive name, like "Removed marketing test accounts" or "Set OrderDate to Date type." This creates a clear audit trail and makes it infinitely easier to find the exact step you need to remove later.
2. Duplicate Queries Before Experimenting: If you're about to try a complex series of transformations and you're not sure if they will work, don't risk messing up your primary query. Instead, right-click the query in the Queries pane and select "Duplicate." This creates an identical copy that you can edit and experiment on safely. If it works, you can apply your learnings to the original query. If it doesn't, you can just delete the duplicate with no harm done.

Final Thoughts

The "pending query changes" message in Power BI isn't an error, but a checkpoint. It provides a crucial buffer between the raw data work you're doing and the live report your team relies on. Understanding the options - applying, discarding, or selectively removing steps - puts you in full control of your data transformation workflow and helps you turn potential frustrations into productive fixes.

Working in powerful tools like Power BI shows how much manual work can go into getting data ready for analysis. But pulling all your data together and cleaning it doesn't have to be a multi-step, technical process. To help with this, we built Graphed to connect to all your marketing and sales data sources (like Google Analytics, Salesforce, and Facebook Ads) and automate the reporting process. Instead of working through lists of applied steps, you can just ask in plain English for the report you need - like, "Show me a dashboard of my ad spend vs. revenue last month" - and get a live, automated dashboard in seconds, skipping the manual data prep entirely.