Table.SelectRowsWithErrors

 

This topic applies to the Power Query Formula Language which can be used with Power Query and Power BI Desktop to build queries that mashup data. See the list of function categories.

Returns a table with only the rows from table that contain an error in at least one of the cells in a row.

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

ArgumentDescription
tableThe Table to check.
optional columnsOnly cells in the column list are inspected for errors.
  • Only errors detected by directly accessing the cell are considered. Errors nested more deeply, such as a structured value in a cell, are ignored.
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"]  
  
}  
  
))  

CustomerIDNamePhone
ErrorBob123-4567
Show: