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
TableAction.DeleteRows( table as table ) as any
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.SelectRows to apply a filter to
table before using
The function raises an evaluation error if
table is not updatable.
The action raises an execution error if the operation fails.
table may be left in a partially updated state if an execution error occurs.
Other functions related to TableAction.DeleteRows are: