Star-schema topology deviations (snowflake, bridge, fact-to-fact)
"Star-schema topology deviations (snowflake, bridge, fact-to-fact)" is one of the modeling checks Auditabi runs on a Power BI semantic model. The model is not a star: dimensions snowflake into sub-dimensions, fact tables join each other, or a bridge is missing. It is a critical finding: it breaks refresh, returns wrong numbers or exposes data, so it should be fixed before publishing. Flatten snowflakes into the dimension in Power Query, connect facts through shared dimensions, and add bridge tables only where the business relation is many-to-many.
What is detected
The model is not a star: dimensions snowflake into sub-dimensions, fact tables join each other, or a bridge is missing. Every added hop costs performance and makes filter behaviour harder to predict.
Why it matters
Breaks refresh, returns wrong numbers, or exposes data. Fix before publishing.
How to fix it
Flatten snowflakes into the dimension in Power Query, connect facts through shared dimensions, and add bridge tables only where the business relation is many-to-many.
Does your model fail this check?
Free static audit with the exact objects, no account, nothing stored.