All checks
ModelModelingMedium

Bridge table connected on one side only

"Bridge table connected on one side only" is one of the modeling checks Auditabi runs on a Power BI semantic model. n table(s) look like a bridge (two key columns, no measure) but are related on one side only. It is a medium-severity finding: the model still works, but results are wrong in some filter contexts, slow, or fragile under change. Relate both sides, and set the filter direction deliberately on the bridge.

What is detected

n table(s) look like a bridge (two key columns, no measure) but are related on one side only. The many-to-many they were built for does not resolve, and filters stop at the bridge.

Why it matters

Wrong in some filter contexts, slow, or fragile under change. Fix in the next iteration.

How to fix it

Relate both sides, and set the filter direction deliberately on the bridge.

Does your model fail this check?

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

Audit a model

More Model checks