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]
Related functions
Other functions related to Table.SelectRowsWithErrors are:
2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy