How To Remove Blank Rows in Power BI?

Objective For ‘How To Remove Blank Rows in Power BI?’

This step-by-step recipe will show you how to remove null values in Power BI.

Steps Showing How To Delete Rows in Power BI

Below are the steps to show you how to perform Power BI remove null rows.

Step 1 - Open Power Query Editor

Right-click on the dataset and select the edit query option. This will redirect us to Power Query Editor

Step 2 - Select The Remove Blank Rows Option

To remove blank rows-

Home -> Remove Rows -> Remove Blank Rows

Step 3 - Close And Apply

It will remove all the blank rows from the data.

What Are The Different Ways To Remove Blank Rows in Power BI Table?

There are three main ways to remove null rows in Power query-

1. Using the Remove Rows feature- This is the simplest way to remove blank rows in Power BI. However, it can be time-consuming if there are a lot of blank rows.

2. Using the Conditional Formatting feature- This is a more efficient way for Power query remove null rows. However, it can be challenging to set up if the blank rows are not all in the same column.
3. Using a Custom Formula- This is the most flexible way to perform Power BI delete rows. However, it can be the most difficult to set up.