Table.Buffer / List.Buffer
"Table.Buffer / List.Buffer" is one of the performance checks Auditabi runs on a Power BI semantic model. n query(ies) buffer a table or list in memory. It is a medium-severity finding: the model still works, but results are wrong in some filter contexts, slow, or fragile under change. Remove the buffer unless it fixes a proven non-determinism issue; push filters upstream so the buffered set is tiny.
What is detected
n query(ies) buffer a table or list in memory. Buffering stops query folding for every subsequent step and loads the full table into the mashup engine's memory.
Why it matters
Wrong in some filter contexts, slow, or fragile under change. Fix in the next iteration.
How to fix it
Remove the buffer unless it fixes a proven non-determinism issue; push filters upstream so the buffered set is tiny.
Reference
Microsoft: Query folding — steps that prevent folding
Does your model fail this check?
Free static audit with the exact objects, no account, nothing stored.