Forum Discussion
RLS with multiple columns
Not sure to have catched it right.
Do you have already implemented/defined RLS groups (Desktop) and maybe assigned users to these groups (in Service)?
Regards
We did try that already, having seperate groups but it still displays the same result over stating the sales. Since the user can be in multiple groups it keeps pulling data that isn't relevant to them in one category but is in another category.
Just copied your data above and tried to set RLS.
Result:RLS is set up this way:
RegardsThis may be a stupid question, we did try that method but the user can't choose their role correct?
So when both roles are selected you will get the results I was getting before. We added buttons to try and seperate the two roles but still not effective at seperating the roles (parameters didn't quite work either).Of course it will. What do you expect as a result when you select two roles.
When "John Doe" is evaluated PBI will show the result set.
Why would you use both roles at the same time? You are Seller or Admin role.
Does it make sense to establish RLS in that case?
That`s my undestanding on this topic.
Regards