Search notes:

Power Query M formula language standard library: Table.RemoveRowsWithErrors

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
   }),
   tabNoErr = Table.RemoveRowsWithErrors(tab)
in
   tabNoErr

See also

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

Index