ModelPerformanceLow
Small dimension left in DirectQuery
"Small dimension left in DirectQuery" is one of the performance checks Auditabi runs on a Power BI semantic model. n dimension(s) are in DirectQuery mode. It is a low-severity finding: hygiene and maintainability, worth fixing when you next touch the object. Import the dimensions and keep DirectQuery for the large fact, in a composite model.
What is detected
n dimension(s) are in DirectQuery mode. Every slicer then queries the source, which is the slowest possible way to populate a list of twenty values.
Why it matters
Hygiene and maintainability. Fix when touching the object.
How to fix it
Import the dimensions and keep DirectQuery for the large fact, in a composite model.
Does your model fail this check?
Free static audit with the exact objects, no account, nothing stored.