How to Remove Unused Columns in Power BI

Working in Power BI often means dealing with data that isn’t perfectly clean. Your data source, whether it's an Excel sheet, a database, or a CRM, is likely filled with columns that are irrelevant to your final report. Keeping these extra columns clutters your data model, slows down your report’s performance, and makes building visualizations a confusing chore. This tutorial will walk you through simple and effective ways to remove those unused columns using the Power Query Editor, ensuring your reports are fast, clean, and easy to manage.

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

Why You Should Remove Unused Columns in Power BI

You might be tempted to just ignore those extra columns, but taking a few moments to remove them offers significant benefits. It’s not just about aesthetics, it's about building a better, more efficient report from the ground up.

1. A Major Performance Boost

This is the most important reason. Power BI’s data engine, VertiPaq, is highly optimized for columnar data. It compresses data one column at a time. The fewer columns it has to process and store, the better the compression and the faster your report will be. When you remove a dozen unused columns from a table with a million rows, you're not just removing a dozen cells, you're removing 12 million data points that Power BI otherwise has to load, compress, and hold in memory. This leads to:

• Faster data refreshes: Less data to pull from the source and process.
• Quicker visuals: A leaner data model means visuals and DAX calculations respond more quickly.
• Small file sizes: Your .pbix file will be smaller, making it easier to share, save, and manage.

2. A Cleaner, More Usable Data Model

When you're in the report-building phase, the Fields pane on the right-hand side is your primary workspace. If it’s cluttered with dozens of columns like "Column1_deprecated," "internal_ID," or empty fields, finding the data you actually need becomes a headache. A clean data model with only relevant columns makes the report development process much faster and less error-prone. Your colleagues (and your future self) will thank you when they can easily understand the purpose of each field without having to guess.

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

3. Simpler and More Accurate DAX

Writing Data Analysis Expressions (DAX) is an essential part of creating insightful Power BI reports. When your data model is cluttered, writing DAX becomes more difficult. You have to scroll through a long list of fields, increasing the risk of selecting the wrong one. By removing junk columns, you ensure the autofill suggestions in the DAX editor only show relevant fields, helping you write formulas more quickly and with greater accuracy.

Your Best Friend for Data Cleaning: The Power Query Editor

The single best place to handle data cleaning tasks like removing columns is the Power Query Editor. Think of Power Query as a preparation area where you clean, shape, and transform your data before it ever gets loaded into the main Power BI data model. By removing columns here, you are eliminating them at the source, preventing them from ever taking up memory or slowing down your report.

A common mistake beginners make is to simply "hide" a column in the Report or Data view. While this removes it from the Fields pane in the report-building canvas, the column and all its data are still loaded into your model. Hiding is a presentation feature, not a performance optimization. Removing in Power Query, on the other hand, is a fundamental data transformation that truly discards the data you don't need.

To get started, open your Power BI Desktop file and navigate to the Home tab on the ribbon. Click the Transform data button to launch the Power Query Editor.

Step-by-Step: Four Ways to Remove Columns in Power Query

Once you're in the Power Query Editor, you'll see a preview of your tables. Here are the most effective methods for getting rid of columns you don't need.

Method 1: Select and Remove (The Direct Approach)

This is the most straightforward method and is perfect when you only need to remove a few columns.

1. Click on the header of the column you want to remove to select it.
2. To select multiple columns, hold down the Ctrl key and click on each column header you want to remove. To select a contiguous block of columns, click the first one, hold the Shift key, and click the last one.
3. With your columns selected, you have two options:

Instantly, the columns will vanish from the data preview. More importantly, notice that a new step called "Removed Columns" has appeared in the Applied Steps pane on the right. This keeps a record of your actions, which you can easily undo by clicking the 'X' next to the step name.

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

Method 2: Keep What You Need with "Choose Columns"

What if your table has 150 columns and you only need 10 of them? Selecting the 140 columns to remove would be tedious and error-prone. In this scenario, it’s much more efficient to specify which columns you want to keep.

1. With your table selected, go to the Home tab in the ribbon.
2. In the "Manage Columns" section, click Choose Columns.
3. A dialog box will pop up listing every column in your table. To start with a clean slate, uncheck the (Select All) box at the top.
4. Now, go through the list and tick the boxes only for the columns you want to keep in your final dataset.
5. Click OK.

All other columns will be removed, and a step named "Removed Other Columns" will be added to your Applied Steps. This is the most efficient method for wide, cluttered tables.

Method 3: Quickly Find Columns with "Go To Column"

Sometimes the problem isn't the number of columns to remove but simply finding the right one in a wide table. The "Go To Column" feature is your secret weapon for navigation.

1. In the Power Query Editor, go to the View tab.
2. Click Go To Column.
3. A search box will appear. Start typing the name of the column you are looking for.
4. Power Query will filter the list in real-time. Once you see your column, click on its name, and Power Query will immediately jump to that column in the preview window.
5. From here, you can simply right-click the header and select Remove.

Method 4: A Pro Tip for Removing Columns Dynamically

For more advanced users, you can use Power Query’s M language to remove columns based on a condition, such as a name or a property. For instance, imagine you want to remove any column that has the word "temp" in its name.

You can do this by opening the 'Advanced Editor' from the 'Home' tab and adding a custom step. This brief snippet of M code creates a list of column names containing "temp" and then removes them:

// Find column names that contain "temp"
ColumnsToRemove = List.Select(Table.ColumnNames(Source), each Text.Contains(_, "temp")),
// Remove those columns from the table
RemoveTempColumns = Table.RemoveColumns(Source, ColumnsToRemove)

While this goes beyond point-and-click, it shows the power under the hood of Power Query for automating data cleaning on a larger scale.

Best Practices & Things to Watch Out For

As you clean up your tables, keep these tips in mind to avoid common issues.

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

Don't Just Hide, Actually Remove

It bears repeating: hiding columns in the Report View does not improve performance. It only cleans up your view while building. To get the performance benefits, you must remove the columns in the Power Query Editor.

Check for Column Dependencies

Be careful not to remove a column that is needed elsewhere. A classic example is removing an ID column (like customerID or productID) that seems useless on its own but is essential for creating relationships between your tables. Removing a primary or foreign key will break your data model's relationships. Power BI will usually raise an error during the data refresh if a column used in a later step (like a custom column formula) is removed, but it's best to be proactive.

Use the Applied Steps Pane to Your Advantage

The "Applied Steps" pane is your safety net. If you accidentally remove the wrong column, you haven’t permanently damaged your data. Simply find the "Removed Columns" step in the list and click the red 'X' next to it to undo the action. This non-destructive workflow is one of Power Query's best features.

Final Thoughts

Cleaning up your data by removing unused columns is one of the most impactful habits you can adopt for building high-performing Power BI reports. It's a simple step that significantly shrinks your file size, speeds up refresh and interaction times, and creates a data model that is far easier for you and your team to work with. Taking a few moments in the Power Query Editor to trim the fat will pay dividends down the line.

The time you spend wrangling columns and manually preparing your data is often the biggest bottleneck to getting real insights. We built Graphed to automate this painful first step. After connecting your marketing and sales data sources in just a few clicks, you can ask for the dashboard you need in plain English. Graphed handles the data preparation in the background, making sure you're analyzing clean, relevant information without ever having to manually remove columns or build reports. You get to focus on what the data means, not the tedious work of getting it ready.