2022 updates MS Excel - Data Cleaning Course Enroll now  
Power BITutorials

Read How to Remove Rows With Errors Using Power Query

1 Mins read

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.

Data Analytics Tricks in Power BI – Guidebook

You too can analyze data like a Data Scientist. No coding needed. No statistics needed.

Analyze & Visualize data using Power BI. (23 tricks in one book)

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

Data Analytics Tricks in Power BI – Guidebook

You too can analyze data like a Data Scientist. No coding needed. No statistics needed.

Analyze & Visualize data using Power BI. (23 tricks in one book)

Related posts
AlteryxTutorials

Alteryx Hotkeys - Alteryx Keyboard Shortcuts

2 Mins read
Top 50+ Alteryx Shortcuts for Windows. Alteryx is popularly known as a Self-Service Analytics tool. Business users can build their data workflows…
AlteryxTutorials

Step By Step Guide to Learn Alteryx

6 Mins read
Alteryx Learning Path: The growth in technology has resulted in growth in understanding. In today’s world, humans – fellow businessmen know the…
Excel VBA CodeTutorials

VBA Code to Clean the Date Format

1 Mins read
When it is useful? Most of the time the most annoying problem is when the data is taken from ERP or other…