Table.Buffer
Reads all of a table's cells and keeps them in memory, giving the same table back.
Group: Table. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
Table.Buffer(table as table, optional options as nullable record) as table| Parameter | Type | Description |
|---|---|---|
table | table | The table to read. |
options | nullable record optional | A record of options, such as BufferMode; the rows are the same with any of them. |
Returns
table. The same rows and columns.
Remarks
- A query's answer is the same with or without it.
- A cell with an error keeps its error: the other cells are still read.
Examples
The same rows
Table.Buffer(#table({"Product", "Price", "Units"}, {{"Chair", 50, 4}, {"Desk", 120, 1}, {"Lamp", 30, 6}}))| Product | Price | Units |
|---|---|---|
| Chair | 50 | 4 |
| Desk | 120 | 1 |
| Lamp | 30 | 6 |