Bidirectional relationship in a model with row-level security
"Bidirectional relationship in a model with row-level security" is one of the reliability checks Auditabi runs on a Power BI semantic model. n bidirectional relationship(s) coexist with RLS roles. It is a critical finding: it breaks refresh, returns wrong numbers or exposes data, so it should be fixed before publishing. Make the relationship single-direction, or explicitly verify securityFilteringBehavior for each one and document why it is needed.
What is detected
n bidirectional relationship(s) coexist with RLS roles. Filters from RLS can leak through the reverse direction unless "Apply security filter in both directions" is controlled deliberately, and performance degrades sharply.
Why it matters
Breaks refresh, returns wrong numbers, or exposes data. Fix before publishing.
How to fix it
Make the relationship single-direction, or explicitly verify securityFilteringBehavior for each one and document why it is needed.
Reference
Microsoft: Bidirectional relationships and RLS
Does your model fail this check?
Free static audit with the exact objects, no account, nothing stored.