What is Close and Apply in Power BI?

If you're getting started with Power BI, you've likely spent some time in the Power Query Editor cleaning and transforming your data. And every time you're ready to move on, you face that button in the top-left corner: "Close & Apply." It seems simple enough, but a click reveals three different options - Close & Apply, Apply, and Close - each with a specific purpose. Understanding the difference is fundamental to building reports efficiently and avoiding frustration.

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

This article will break down exactly what "Close & Apply" does in Power BI. We'll explore each of its three functions so you know precisely which one to use and when.

The Power Query Editor: Your Data's Transformation Hub

Before we dive into the buttons, it's important to understand where you are when you see them. When you first import data into Power BI, it opens the Power Query Editor. Think of this as your data's workshop or staging area. It's a separate window from the main Power BI Desktop report view for a reason.

This is where you perform all your data preparation (often called ETL - Extract, Transform, Load):

• Cleaning Data: Removing errors, blank rows, or extra spaces.
• Shaping Data: Unpivoting columns, renaming headers, splitting columns, or merging queries.
• Filtering Data: Removing irrelevant rows to work with a smaller, more relevant dataset.
• Changing Data Types: Ensuring dates are read as dates, numbers as numbers, and text as text.

Every change you make in the Power Query Editor is recorded as a step in the "Applied Steps" pane on the right. These steps form a recipe for transforming your raw data into a clean, usable format. However, none of these recipe steps are actually performed on the data that will be used in your report visualizations until you tell Power BI to do so. That’s where the "Close & Apply" family of commands comes in.

Breaking Down the Buttons: A Tale of Three Choices

In the "Home" tab of the Power Query Editor ribbon, you'll find the "Close & Apply" button. It serves as your exit from the data workshop, but how you exit matters. Let’s look at each option individually.

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

1. Apply

When you click Apply, Power BI takes all the transformation steps you've created and applies them to your data source. It then loads this newly shaped data into your data model, which lives behind the scenes in the main Power BI report view. However, the Power Query Editor window stays open.

When Should You Use "Apply"?

The "Apply" command is your best friend when you’ve made a significant number of changes and want to do one of two things:

• Save your progress: You want to commit your transformations to the data model without leaving the Power Query environment. Think of it as a checkpoint. If the application crashes, your applied changes will be there when you restart.
• Test for errors: After performing complex transformations like merging queries or changing multiple data types, you want to see if the changes will load successfully without errors. Clicking "Apply" triggers the data load process. If there's an issue (like a data type mismatch), Power BI will tell you. Because you're still in the Power Query Editor, you can immediately troubleshoot and fix the problem.

Essentially, use "Apply" when you're in the middle of a complex data cleaning session and aren't ready to start building visuals yet, but you want to check your work and make sure everything loads correctly.

2. Close

The Close option is straightforward: it attempts to close the Power Query Editor window and take you back to the main Power BI report view. The key here is what happens depending on your unsaved changes.

If you haven't made any new transformations since the last time you hit "Apply," the window will simply close. But if you have unapplied changes, Power BI will protect you from yourself with a pop-up dialog box that asks, "You have pending changes, do you want to apply them?"

You’ll then have three choices:

• Apply changes: Same as clicking "Close & Apply."
• Keep changes: A newer option that saves the Power Query steps but doesn't apply them to the data model. You can open Power Query again later, and the unapplied steps will be there waiting. This is useful for saving M code that isn't quite working yet without breaking your model.
• Discard changes: This throws away all the new transformations you've made since your last "Apply." It’s an escape hatch.

When Should You Use "Close"?

Use "Close" primarily when you want to discard your recent work. Maybe you were experimenting with a transformation, and it didn't turn out right, creating a ton of errors. Instead of manually deleting each of the applied steps, you can simply click "Close" and then "Discard changes" to revert to your last saved state. It’s a clean way to say, "Oops, I'm just going to pretend that never happened."

3. Close & Apply

This is the workhorse command and the one you'll use most often. Close & Apply is a two-part command that does exactly what it says:

1. First, it performs the Apply function: It saves all your transformation steps and loads the clean, transformed data into the Power BI data model.
2. Second, it performs the Close function: It shuts down the Power Query Editor window and returns you to the main Power BI Desktop interface, where you can now see your updated queries in the Fields pane and use them to build visuals.

When Should You Use "Close & Apply"?

You use "Close & Apply" when you believe your data preparation work is complete for now. You've cleaned up the data, it's in the shape you want, and you're confident it's ready for analysis. Clicking "Close & Apply" is the final step in the data transformation process and your entry ticket into the report-building canvas.

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

Putting It All in Context: Practical Scenarios

Let's walk through some day-to-day scenarios to solidify when to use each command.

Scenario 1: Merging Multiple CSV Files You're a marketing analyst tasked with combining sales data from 12 different monthly CSV files into one master table. After pulling them all into a folder and consolidating them in Power Query, you've performed several more steps: removing duplicate columns, filtering out test transactions, and standardizing product names. This took about 20 minutes.

✅ Your best move: Before going any further, click Apply. Power BI will attempt to load the dozens of megabytes of data. You suddenly get a compatibility error from two of the files. Because you only used "Apply," you're still in the Power Query Editor and can quickly diagnose which file caused the issue without losing your place.

Scenario 2: The Experimental Column You have a table of customer feedback, and you're curious what would happen if you used the "Split Column by Delimiter" function on the comments to extract keywords. You try a few different delimiters - spaces, commas - but the result is a messy table with hundreds of new columns that aren't useful at all.

✅ Your best move: Instead of undoing all those messy steps one by one, simply click Close. When Power BI asks if you want to apply your changes, click "Discard changes." Your query is instantly restored to its clean, pre-experimentation state.

Scenario 3: Go Time! You’ve imported some financial data from an Excel worksheet. In Power Query, you promoted the first row to headers, unpivoted the month columns, and changed the 'Amount' column to a fixed decimal number format. The data now looks perfect and is ready for your report.

✅ Your best move: Click Close & Apply. The Power Query window closes, Power BI loads your perfectly formatted data, and moments later you're back in the main view, ready to drag fields onto the canvas and build your financial dashboard.

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

A Final Tip: The Waiting Game

One last thing to remember: with large datasets, the "Apply" process (whether triggered by "Apply" or "Close & Apply") can take some time. Sometimes minutes. Why? Because Power BI is meticulously re-running every single applied step you've created, from the initial data source connection to the final data type change, across every single row of your data.

If it seems to be taking too long, be patient. You'll see a small pop-up window showing which query is being processed and how many rows have been loaded. This patience is a rite of passage for every Power BI user and a great reminder to perform as many filtering and data-reducing steps as early as possible in your transformation process.

Final Thoughts

The "Close & Apply," "Apply," and "Close" commands in Power BI give you precise control over your data preparation workflow. Using them correctly helps you work efficiently, checking for errors with "Apply," making a quick exit with "Close," and finalizing your hard work with "Close & Apply." Mastering them is a small but essential step on your path to building powerful and reliable reports.

That journey through complex BI tools, manual steps in a Query Editor waiting for data to load, highlights why reporting can still be such a time-consuming process for many teams. At Graphed, we aim to eliminate this friction entirely. We’ve designed a platform that automates the tough parts by allowing you to simply connect your data sources - like Google Analytics, Shopify, or Salesforce - and build the dashboards you need using simple, plain-English conversations. This lets you skip the technical steps and get straight to insights in seconds, not hours.