Table.SelectRowsWithErrors

Updated on

Table.SelectRowsWithErrors is a Power Query M function that returns a table with rows that contain errors in at least one of the cells, with an optional columns list to inspect specific columns for errors. The function returns a table with the rows containing errors.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

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

Description

Table.SelectRowsWithErrors returns a table with rows from the input table that contain errors in at least one cell. If a column list is specified, only those columns are checked for errors.

Examples

Select names of customers with errors in their rows.

// Output: {"Bob"}
Table.SelectRowsWithErrors( 
    Table.FromRecords( {
        [CustomerID = ..., Name = "Bob", Phone = "123-4567"],
        [CustomerID = 2, Name = "Jim", Phone = "987-6543"],
        [CustomerID = 3, Name = "Paul", Phone = "543-7890"],
        [CustomerID = 4, Name = "Ringo", Phone = "232-1550"]
    } )
 )[Name]

Other functions related to Table.SelectRowsWithErrors are:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/table-selectrowswitherrors