Search notes:

Power Query M formula language standard library: Table.SelectRowsWithErrors

let
   tab = #table(
    {  "id", "val 1", "val 2"},
    {
      {  1 , "one"  , "foo"        },
      {  2 , "two"  , "bar"        },
      {  3 , "three", "baz", "xyz" }, // Note the additional column
      {  4 , "four"                }  // Note the missing column
   }),
   taberr = Table.SelectRowsWithErrors(tab)
in
   taberr

See also

The Power Query standard library and its function Table.RemoveRowsWithErrors.

Index