How to Remove a Column in Power BI

Removing a column in Power BI is a fundamental step in cleaning your data and building efficient reports. Knowing the right way to do it can significantly improve your report's performance and make your data model much easier to manage. This tutorial will walk you through the simplest and most effective methods for deleting columns using the Power BI Power Query Editor.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Why Should You Remove Columns in Power BI?

Before jumping into the "how," let's quickly cover the "why." Deleting columns isn't just about deleting data, it's a strategic move that pays off in several ways:

• Improved Performance: This is the biggest reason. Power BI's data engine, VertiPaq, is highly optimized for columnar data, leading to smaller file sizes and faster data refreshing, which is crucial as your datasets grow.
• Reduced Clutter: A clean data model is a happy data model. When you open your file in the Report View, the Fields pane on the right won't be clogged with dozens of irrelevant columns you'll never use. This makes finding the fields you need much faster.
• Simplified Model Management: Your data model becomes far easier to navigate, understand, and maintain over time. When collaborating with others, a streamlined model prevents confusion and helps everyone get on the same page quickly.
• Better User Experience: For the end-users of your reports, fewer unnecessary columns mean less confusion. It prevents them from trying to filter or slice data by a field that provides no value, leading to a more intuitive and useful report.

The Right Place to Work: Power Query Editor

While you can "hide" columns in Power BI’s Report View, this is not the same as removing them. Hiding a column simply removes it from view in the Fields pane, but it remains fully loaded in your data model, taking up space and memory. Hiding is useful for things like keeping an ID column that's needed for a relationship but shouldn't be used in visuals.

For permanent deletion and performance gains, the Power Query Editor is the correct place to work. It's the data transformation layer of Power BI, allowing you to shape and clean your data before it gets loaded into the model.

To access the Power Query Editor, go to the Home tab in the main Power BI Desktop window and click the Transform data button.

Every change you make here, including removing a column, is recorded as a step. This means the removal is applied automatically every time you refresh your data, ensuring a consistent and clean dataset.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Method 1: Using the "Remove Columns" Button (The Easiest Way)

This is the most straightforward and common method for deleting one or more columns. It’s perfect for when you have a specific list of columns you want to get rid of.

Step 1: Open the Power Query Editor and Select Your Table

After clicking Transform data, the Power Query Editor window will open. On the left side, you'll see a list of your queries (your tables). Click on the table you wish to modify.

Step 2: Select the Column(s) You Want to Remove

Next, you’ll need to highlight the column headers. You have a few options for selection:

• To select a single column: Just click on the column header.
• To select multiple adjacent columns: Click on the first column header, hold down the Shift key, and then click on the last column header in the range. All columns in between will be selected.
• To select multiple non-adjacent columns: Click on the first column header, hold down the Ctrl key (or Command on a Mac), and then click on each additional column header to add it to your selection.

Step 3: Click the "Remove Columns" Button

With your columns selected, navigate to the Home tab on the Power Query ribbon. In the "Manage Columns" group, click the Remove Columns button.

The selected columns will vanish instantly. On the right-hand side of the screen, in the APPLIED STEPS pane, you’ll see a new step appears named "Removed Columns." This step records your action, making it easy to undo if you make a mistake.

Method 2: Right-Click and Remove

For an even faster workflow, you can use the right-click context menu. This action produces the exact same result as the ribbon button but requires fewer mouse movements.

Step 1: Select Your Columns

Follow the same process as above to select one or more columns in the Power Query Editor that you want to delete.

Step 2: Right-Click and Select "Remove"

Right-click on any of the selected column headers. A context menu will appear. Simply select Remove from this menu.

Again, the columns will be deleted, and a "Removed Columns" step will be added to your Applied Steps.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Method 3: "Choose Columns" for Wide Tables

What if you have a table with 100 columns but you only need 10 of them? Selecting the 90 columns you want to delete would be tedious. In this scenario, it’s far more efficient to select the columns you want to keep.

Step 1: Navigate to "Choose Columns"

With your desired table open in the Power Query Editor, go to the Home tab. In the "Manage Columns" group, click the Choose Columns icon.

Step 2: Select the Columns You Want to Keep

A new pop-up window will appear, listing every column in your table. All columns will be checked by default. Now you can easily uncheck the ones you want to remove.

For a huge table, an even faster approach is to first uncheck the (Select All Columns) box, which will deselect everything. Then, go down the list and check only the handful of columns you want to keep.

Step 3: Click OK

After clicking "OK," Power Query will remove all the unselected columns. In your Applied Steps, you’ll see a step named "Removed Other Columns," signifying that you took an inclusive (keep) rather than exclusive (remove) action. This method is incredibly robust because if new columns are ever added to your original data source, this step will automatically remove them during the refresh unless you edit the step to include them.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

How to Undo a Column Removal

Mistakes happen. Luckily, the Power Query Editor makes them easy to fix. The APPLIED STEPS pane on the right side of the screen tracks every transformation you make, in order.

If you remove a column and immediately realize you need it back, just find the "Removed Columns" or "Removed Other Columns" step in the list and click the red "X" icon next to it. Poof! The step is deleted, and your columns are back, with no harm done.

If you used the "Choose Columns" method and want to add just one column back in, you don't have to delete the step. Instead, click the gear icon to the right of the "Removed Other Columns" step. This will reopen the "Choose Columns" window, allowing you to modify your selection.

Best Practices for a Cleaner Data Model

• Remove early: As a rule of thumb, remove unnecessary columns as one of your very first steps in the Power Query Editor. This simplifies all subsequent transformations.
• Document your steps: For complex queries, you can right-click any step and choose "Properties" to rename it and add a description. Changing "Removed Columns" to "Removed all location IDs except Primary" can save a lot of head-scratching later.
• Think "Keep" not just "Remove": For tables from sources like Salesforce, an email platform, or an ads manager, always lean towards using the "Choose Columns" method. These sources often add new fields, and choosing what to keep ensures your model stays clean automatically.
• Close and Apply: Once you're finished with all your transformations in the Power Query Editor, don't forget to click the Close & Apply button in the top-left corner to load your clean data into the Power BI model.

Final Thoughts

Mastering how to remove columns in Power BI is a small skill that has a massive impact on your report's efficiency, speed, and usability. By using the Power Query Editor and choosing the right method - whether it’s selecting columns to remove or choosing which ones to keep - you ensure your final report is built on a solid, streamlined foundation.

Processes like this are essential, but they can still feel like a manual chore, especially when repeated across dozens of reports. At Graphed, we’ve built an AI data analyst to automate this entire workflow. Instead of going through the manual steps of connecting data, opening Power Query, and cleaning up your model, you can just ask a question like "Show me my top 10 products by revenue from Shopify" in plain English. We connect directly to your data sources, handle the data prep for you, and instantly visualize the answer in a live, interactive dashboard. It allows you to skip straight to the insights you need, saving countless clicks and manual steps in the process of building clean, useful reports. Explore what it feels like to chat with your data by signing up for Graphed today.