Remove rows with errors (Power Query)

Note: Power Query is known as Get & Transform in Excel 2016. Information provided here applies to both. To learn more, see Get & Transform in Excel 2016.

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

Was this information helpful?

How can we improve it?

How can we improve it?

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

Thank you for your feedback!