TableAction.DeleteRows

Updated on

TableAction.DeleteRows is a Power Query M function that creates an action to delete rows from a table. The action returns a table containing the deleted rows before the action executed.

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

Syntax

TableAction.DeleteRows( table as table ) as any

Description

Creates an action to delete the rows in table. The action returns a table containing the deleted rows as they appeared in table before the action executed.

To delete a subset of the rows in table, use Table.SelectRows to apply a filter to table before using TableAction.DeleteRows.

The function raises an evaluation error if table is not updatable.

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.DeleteRows are:

BI Gorilla Blog

Contribute » | Contributors: Rick de Groot