Updated on

TableAction.InsertRows is a Power Query M function that creates an action to insert rows into a table, returning a table containing the inserted rows after the action executes.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365


   table as table,
   rowsToInsert as table,
) as any


Creates an action that inserts rowsToInsert into table. The action returns a table containing the inserted rows as they appear in table after the action executes.

Target-specific default values are used for the columns in table that are not specified in rowsToInsert.

The function raises an evaluation error if table is not updatable or if rowsToInsert is not compatible with table.

The action raises an execution error if the operation fails.

NOTE: table may be left in a partially updated state if an execution error occurs.

Other functions related to TableAction.InsertRows are:

Contribute » | Contributors: Rick de Groot