NEW! FREE 90 Minutes Excel VBA Course for Beginners! Watch now 

Power BITutorials

Read How to Remove Rows With Errors Using Power Query

1 Mins read
DATA TABLE BEFORE REMOVING ERROR ROWS

Do you know that Power Query can clean your data and remove rows that have inaccurate data? If you are not aware of this feature then go through the below steps.

Remove Rows With Errors By Power Query

Let’s take an example. As shown in the below picture there is some revenue that has invalid values. Therefore we want to remove these rows.

 

Step 1: Load the data in Power Query Editor

Load the data in Query Editor and note the rows that contain the error values. Here, three rows contain error values.

DATA TABLE BEFORE REMOVING ERROR ROWS

Step 2: Remove Errors

To remove the error rows, follow the below steps:

    • Right-click on the column that consists of error rows
    • Click on the Remove Errors option

REMOVE ERROR ROWS

 

Step 3: Close & Apply

Click Close & Load from the Home tab to apply the pending changes.

You now have your new data table without any inaccurate rows!

DATA TABLE AFTER REMOVING ERROR ROWS

If you wish to learn Power Query and build a career in data visualization or BI, then check out our Power Query Training Certification which comes with instructor-led live training and real-life project

You can know more :

Related posts
Power BITutorials

Opportunity Analysis Power BI Dashboard

1 Mins read
Information: A software company that has two sales channels: direct and partner. The sales manager created this dashboard to track opportunities and…
Power BITutorials

Procurement Analysis Power BI Dashboard

1 Mins read
Information: It analyzes a manufacturing company’s spending on vendors by category and location. we explore these areas: Who the top vendors are…
Power BITutorials

Retail Analysis Power BI Dashboard

1 Mins read
Information: It analyzes retail sales data of items sold across multiple stores and districts The metrics compare this year’s performance to last…