Forum Discussion
RLS roles combination& Security Filtering Behavior = Both relationships
Hi all, We have implemented the RLS security for the Power BI report and difined set of different filter for each role via DAX. This works fine when user has single role membership, but throws...
Hi Triggg ,
There is a similar thread that you could reference firstly.
If it can't work for you, please share a dummy file that we can test.
No, the thread you refer to is not the same problem. I have the same issue as Triggg, and it's nothing to do with both direction links (it's a single for my case), but both RLS profiles applied.
Have a look at
As far as we could tell in the December release of power bi desktop and service many to many cardinality relationships stopped working when multiple roles were selected.
There is a ticket in with microsoft but no response yet.
I believe you cna force it to work by replacing many to many relationships with a bridge table type setup but that's far from ideal.
