Forum Discussion
Different RLS criterias on different sheets
Finaly managed to solve this problem!
I created a new merged query in PowerQuery with all activityID and IncidentID.
Added one column for owner of Incident
Added one column for owner of Activity
Set relationship from Incident->Securitytable->Activity
Created a RLS role for this new Table:
('Security CaseActivity'[BusinessUnitIncident] = 'Affärsenhet'[Min affärsenhet])
||
('Security CaseActivity'[BusinessUnitActivity] = 'Affärsenhet'[Min affärsenhet])The saga continues. The soloution was working but was way to slow in production.
So now I have another new working solution that is fast!
Ended up merging my Incidents and Incident releted Activitys. So now I only have 1 fact table to work with. Can thereby create a Row level security Role using UserPinciplenamn() and two filters looking for Business Unit on Incident OR Business Unit on Acitivity.
-----
[Businessunit Incident] = [My Business Unit]
||
[Businessunit Activity] = [My Business Unit]-----
[My Business Unit] is a measure on Dimension Business unit:
= LOOKUPVALUE('SystemUser'[businessunitid];'SystemUser'[internalemailaddress];USERPRINCIPALNAME();'SystemUser'[isdisabled];False())
Thank you fpr your reply.
Yes I use relationship between BU and SystemUser.
I also use USERPRINCIPALNAME() in the RLS.
I can create two different Security Roles that works for Page 1 Or Page 2. But nothing that works for both at the same time.
I will continiue to use page filters instead of security filters but would be really interested to know if there is a better solution.
Hi Bian ,
It seems you did it in the right way. Maybe your rules aren't applied to any user.
Can you test it in the Desktop by "view as role"?
Best Regards,
Yes I used view as Role.
The Problem is that the two pages needs to filter the Case table in different ways.
Page 1 needs to show 800 rows
Page 2 need to show 850 rows
If I create a RLS that supports page 1. Page 2 will be missing 50 rows since it's filtered out with the security filter.
Hi Bian ,
That means you need to adjust the conditions. If the conditions conflict with each other, I'm afraid the RLS could not be the solution.
BTW, can you share the details of the conditions?
Best Regards,
Finaly managed to solve this problem!
I created a new merged query in PowerQuery with all activityID and IncidentID.
Added one column for owner of Incident
Added one column for owner of Activity
Set relationship from Incident->Securitytable->Activity
Created a RLS role for this new Table:
('Security CaseActivity'[BusinessUnitIncident] = 'Affärsenhet'[Min affärsenhet])
||
('Security CaseActivity'[BusinessUnitActivity] = 'Affärsenhet'[Min affärsenhet])