All checks
ModelPerformanceLow

Mixed storage modes (composite model)

"Mixed storage modes (composite model)" is one of the performance checks Auditabi runs on a Power BI semantic model. The model mixes n storage mode(s) across tables. It is a low-severity finding: hygiene and maintainability, worth fixing when you next touch the object. Confirm the DirectQuery tables need to be live; set dimensions shared with DirectQuery facts to Dual.

What is detected

The model mixes n storage mode(s) across tables. Composite models are legitimate but every cross-mode relationship becomes a limited relationship with different semantics.

Why it matters

Hygiene and maintainability. Fix when touching the object.

How to fix it

Confirm the DirectQuery tables need to be live; set dimensions shared with DirectQuery facts to Dual.

Does your model fail this check?

Free static audit with the exact objects, no account, nothing stored.

Audit a model

More Model checks