How to Delete Rows in Power BI

Need to clean up your dataset by removing some rows in Power BI? It's one of the most fundamental steps in data preparation, but it isn't always as straightforward as highlighting a row and clicking 'delete' like in Excel. This guide will walk you through the proper, repeatable ways to delete rows in Power BI using the Power Query Editor, from removing the top few rows to filtering out data based on specific conditions.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Bother Removing Rows? The Core of Data Cleaning

Before jumping into the "how," let's quickly cover the "why." Deleting rows isn't just about making your dataset smaller, it's about making it accurate and useful. Most of the time, you'll be removing rows for one of these reasons:

• Irrelevant Headers or Footers: Many data exports from other systems (like CSVs or text files) include extra header rows with titles, report-generated dates, or footer rows with a summary like "Grand Total." These need to go so Power BI can correctly identify your column headers and data types.
• Blank or Null Rows: It’s common to find completely empty rows in your data, which can throw off calculations and create clutter in your visuals. These are usually safe to remove entirely.
• Errors: Source data can sometimes contain error values that need to be removed before you can perform calculations on a column.
• Conditional Irrelevance: You might need to remove rows based on certain rules. For example, you may want to exclude sales from a specific region, remove data from before a certain date, or get rid of all entries marked as "Test" or "Cancelled."
• Duplicates: A dataset might contain perfectly duplicated entries due to a system glitch or manual data entry error. Removing them ensures metrics like counts and sums are accurate.

In all these cases, the goal is the same: to create a clean, trustworthy dataset that leads to reliable reports.

Your Data Shaping Toolkit: The Power Query Editor

In Power BI, almost all data cleaning and transformation happens in one place: the Power Query Editor. Think of Power Query as your workshop where you shape and prepare your raw data before it gets loaded into your Power BI report model for visualization.

Any changes you make here - including deleting rows - are recorded as repeatable steps. This means every time you refresh your data, Power Query will automatically apply the same cleaning process, ensuring your report stays up-to-date and consistent without any extra manual work.

To access it, go to the Home tab in Power BI Desktop and click Transform Data. This will open the Power Query Editor window.

Method 1: Removing Rows by Position

Sometimes you just need to chop off the top or bottom of your dataset. This is common when dealing with exports that include branded headers or footnotes.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Removing Top Rows

Imagine your CSV export always comes with three extra lines at the top: the report title, the date it was run, and a blank line. These aren't your column headers, and they'll mess up Power BI's automatic data type detection. You can easily remove them.

How to do it:

1. With your query selected in the Power Query Editor, go to the Home tab.
2. In the "Reduce Rows" group, click the Remove Rows dropdown menu.
3. Select Remove Top Rows.
4. A small window will pop up. Enter the number of rows you want to remove from the top (e.g., 3).
5. Click OK.

The top three rows will vanish, and Power BI will likely now be able to correctly identify your actual column headers (You might need to use the "Use First Row as Headers" feature after this step).

Removing Bottom Rows

Similarly, datasets frequently end with summary rows, like "Total," "Subtotal," or "Data exported from system X." These rows don’t contain individual data points and can skew your aggregated visualizations.

How to do it:

1. In the Home tab, click the Remove Rows dropdown.
2. Select Remove Bottom Rows.
3. Enter the number of summary or footer rows you want to trim from the end of the table.
4. Click OK.

Those useless summary lines are now gone, leaving you with only clean data.

Method 2: Conditional Removal Using Filters

This is by far the most powerful and common way to remove rows. Instead of deleting based on position, you delete based on the values within the cells. The logic is simple: you apply a filter to show only what you want to keep, and Power BI effectively discards everything else.

Filtering Out Blanks or Nulls

If your sales data has rows where the ProductName or CustomerID is empty, those rows are incomplete and probably not useful. Getting rid of them is a top priority for data cleaning.

How to do it:

1. Find the column that contains the blank values.
2. Click the dropdown arrow on that column's header to open the filter pane.
3. By default, Power BI lists all the unique values in that column. Simply un-check the boxes next to (blank) and (null). You might see one or the other, or both.
4. Click OK.

All rows that were empty in that specific column will be removed from your dataset immediately. You can even use the "Remove Empty" shortcut from this same dropdown for a faster way to achieve the same result.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Filtering by Specific Values

Let's say you have a "Status" column and you want to analyze only "Completed" orders. You'll need to remove all rows with statuses like "Cancelled," "Returned," or "Pending."

How to do it:

1. Click the filter dropdown arrow on your "Status" column header.
2. In the list of values, un-check the boxes for every status you want to remove (e.g., "Cancelled," "Returned," "Pending").
3. Alternatively, if you only want to keep a few items, it's faster to click "(Select All)" to un-check everything, and then check only the values you want to keep (e.g., "Completed").
4. Click OK.

This method works for text, numbers, or dates. For example, you can filter a Country column to remove "Canada," a Year column to remove data from "2021," or a Product Category column to remove "Accessories." It's incredibly flexible.

Method 3: Dedicated Tools for Duplicates and Errors

Power Query also has some handy one-click functions located in the ribbon for addressing common data quality issues.

Removing Duplicate Rows

Duplicates can wreak havoc on your analysis, leading to inflated counts and incorrect sums. Power Query gives you a simple way to find and remove identical rows.

How to do it:

1. In the Home tab, click the Remove Rows dropdown.
2. Select Remove Duplicates.

That's it! Power BI automatically scans the entire table and removes any rows that are 100% identical copies of another row.

Pro Tip: To remove rows that are duplicates based on just one or more specific columns (e.g., remove duplicate OrderID rows, regardless of other columns), first select those specific columns (hold Ctrl while clicking the headers), then right-click on one of the selected column headers and choose Remove Duplicates from the context menu.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Removing Rows with Errors

Sometimes, data imports fail and create 'Error' values in your cells. These will prevent you from doing calculations on number columns or properly filtering text. Power Query can excise them in an instant.

How to do it:

1. In the Home tab, again go to the Remove Rows dropdown menu.
2. Select Remove Errors.

Power BI will scan every cell in your table and delete any row that contains an Error in one or more of its cells. This is a very quick way to clean up after a problematic data refresh.

Always Check Your "Applied Steps"

As you perform these actions, you'll notice Power Query is keeping a running list of everything you've done in the Applied Steps pane on the right side of the screen. Each action - filtering a column, removing top rows, deleting duplicates - becomes a step in your data preparation recipe.

This is incredibly powerful for a few reasons:

• It's an Audit Trail: You can click any previous step to see what the data looked like at that point in the process.
• You Can Undo: Did you remove the wrong rows? Just click the 'X' next to that step in the list to delete it. No harm done.
• It's Automated: The next time you click "Refresh" in Power BI, it will re-run this exact sequence of steps on your new data automatically, ensuring your reports are consistently clean.

Final Thoughts

While Power BI takes a much different approach to deleting rows than a simple spreadsheet, its process is far more robust and reliable. By using the tools in the Power Query Editor - like the 'Remove Rows' menu for position-based deletions and column filters for conditional logic - you can build a repeatable, automated data cleaning process that will save you countless hours in the long run.

While mastering tools like Power BI is a valuable skill for deep data analysis, the truth is that much of your time is often spent on these essential but tedious cleaning steps. At Graphed, we help automate this entire pipeline. We allow you to connect your marketing and sales sources directly, and instead of clicking through filter panes and transformation options, you can just describe what you need in plain English. This lets you move from raw data to actionable insights and dashboards in seconds, so you can spend your time making decisions, not prepping data. You can try Graphed for free to see how quickly you can get answers from your data.