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

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×