Table.StopFolding
Gives back the same table; in Power Query, a mark that keeps the later steps from folding into the data source's query.
Group: Table. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
Table.StopFolding(table as table) as table| Parameter | Type | Description |
|---|---|---|
table | table | The table to pass on. |
Returns
table. The table it was given: the same rows and columns.
Remarks
- A query's answer is the same with or without it.
Examples
The rows pass through unchanged
Table.StopFolding(Table.SelectRows(#table({"Product", "Price"}, {{"Chair", 50}, {"Desk", 120}}), each [Price] > 60))| Product | Price |
|---|---|
| Desk | 120 |