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

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/Microsof...', 1758209552, '216.73.216.150', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/Microsoft/Power-Query/M-formula/standard-library/Table/RemoveRowsWithErrors(46): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78