All checks
ModelPerformanceLow

Fact table with more than thirty columns

"Fact table with more than thirty columns" is one of the performance checks Auditabi runs on a Power BI semantic model. n fact table(s) carry more than thirty columns. It is a low-severity finding: hygiene and maintainability, worth fixing when you next touch the object. Move descriptive attributes to dimensions and keep keys and measures on the fact.

What is detected

n fact table(s) carry more than thirty columns. Wide facts usually hide attributes that belong to a dimension; each one is stored for every row.

Why it matters

Hygiene and maintainability. Fix when touching the object.

How to fix it

Move descriptive attributes to dimensions and keep keys and measures on the fact.

Does your model fail this check?

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

Audit a model

More Model checks