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 anyDescription
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.
Related functions
Other functions related to TableAction.DeleteRows are:
2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy