Remove rows with errors (Power Query)

Important   This article applies to Power Query, a data analysis feature available for Excel that lets you discover, combine and refine data. You may need to enable Power Query in Excel. You can also download and install the most recent version of Power Query for Excel, which automatically enables it. Power Query technology is also built into the Power BI Desktop, which is a stand-alone report authoring and data transformation tool for Power BI.

In Power Query, if your query has rows with data errors, you can remove these rows from your query. Data errors can occur as a result of a query or step evaluation, such as changing the type of a column to Number that results in errors for some cells.

To remove rows with data errors across the entire table

  1. In Query Editor, right-click the table icon (Table icon).

  2. Select Remove Errors.

    Remove errors menu - Query Editor

To remove rows with data errors in certain columns

  1. In Query Editor, right-click on the selected columns from where you want to remove the rows containing data errors.

  2. Select Remove Errors.

    Remove Errors context menu - Query Editor

Related Topics

Filter a table

Shape data

Applies To: Excel 2010, Excel 2013

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Change language