Courses / Power Query (Get & Transform)
42. Table.Buffer and buffering
Using Table.Buffer to cache intermediate results to control evaluation and improve or hurt performance deliberately.
Power Query M
Table.Buffer and buffering
Table.Buffer caches a table's in-memory rows so subsequent steps read a stable copy instead of re-evaluating the query each time.
"I kept seeing my query rerun dozens of times and wondered if I could freeze the intermediate result once."
Table.Buffer takes a table value and forces Power Query to evaluate and store its rows in memory immediately, preventing later steps from repeatedly re-evaluating upstream operations.
"I kept seeing my query rerun dozens of times and wondered if I could freeze the intermediate result once."
Table.Buffer takes a table value and forces Power Query to evaluate and store its rows in memory immediately, preventing later steps from repeatedly re-evaluating upstream operations.