Fact table buffered in memory
"Fact table buffered in memory" is one of the performance checks Auditabi runs on a Power BI semantic model. n query(ies) call Table.Buffer on what looks like a fact table. 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, or apply it to the small lookup table it was meant for.
What is detected
n query(ies) call Table.Buffer on what looks like a fact table. Buffering loads the whole table into memory and stops folding for everything after it.
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, or apply it to the small lookup table it was meant for.
Does your model fail this check?
Free static audit with the exact objects, no account, nothing stored.