Forum Discussion
Help with RLS for inactive relationships with USERELATIONSHIP
Hi! We would like to use RLS on seller in this testexample with USERPRINCIPALNAME(). The dimension has multiple relationships to the fact table workorders. And from the documentation we ...
I think I have found the solution in this articel from SQLBI
"DAX limitations with inactive relationships and row-level security (RLS)"
https://www.sqlbi.com/articles/dax-limitations-with-inactive-relationships-and-row-level-security-rls/
I wrote a solution here where you modify the model and no longer need multiple relationships.
https://www.villezekeviking.com/alternative-to-userelationship/