← Back to Table functions

Table.RemoveRowsWithErrors

The function will provide a table that excludes any rows from the original table that have errors in any of the cells. If a list of columns is given, the function will only check for errors in the cel...

Syntax

Table.RemoveRowsWithErrors(table as table, optional columns as nullable list) as table

About

The function will provide a table that excludes any rows from the original table that have errors in any of the cells. If a list of columns is given, the function will only check for errors in the cells of those specified columns.

Explanation

Eliminate the erroneous value from the initial row using the Power Query M function, "RemoveRowsWithErrors." Create a table of records excluding the row containing the error value. The resulting table will consist of records that do not contain any errors.