RLS with user part of Multiple Roles

[Anonymous]

Hi All,

I have two roles in my report for two Page's in the report

1. BS=var _restriction = CALCULATETABLE(VALUES(RLS[SBU]), RLS[User Mail ID] = USERPRINCIPALNAME(),RLS[Report] = "Balance Sheet") Return OR ( IF("ALL" IN _restriction,true(),FALSE()), [SBU] IN _restriction ) 

2. PP=var _restriction = CALCULATETABLE(VALUES(RLS[SBU]), RLS[User Mail ID] = USERPRINCIPALNAME(),RLS[Report] = "Plant Parameter",RLS[plant]="ALL") Return OR ( IF("ALL" IN _restriction,true(),FALSE()), [SBU] IN _restriction )

I have multiple pages in the report therefore, I have created roles pagewise whichever page the user requires access we can add that user to that specific role also on each page we have SBU slicer that will display the list of SBU which user is part of. We are getting the User SBU details from RLS file , which has username, pagename and SBU columns. There is dimension table SBU Sort which is not related to RLS table.

We are having a issue where a user USER1 who is part of both the roles i.e. he should be able to access both BS and PP page but the SBU's he should see in the slicer on both the page is little bit different on BS page he should see only SBU1 in the slicer and on PP page he should see SBU1 and SBU2 in the slicer. 

With above roles created it is not working as expected, when user logs into service portal he is able to see both SBU and it data on both the Pages. Please help me here.

Thanks In Advance.

MS850

[xifeng_L]

Hi @Anonymous ,

RLS cannot apply different roles to different pages because RLS roles are specific to the entire model.

Looking at the scenario you describe, you could use calculation groups to add filters to all measures in bulk, i.e. manually simulate RLS so that you can apply different filters on different pages.

It's hard to describe the whole scenario in words as the process is a bit complicated, so if you can provide the pbix file then I'd be happy to help you with that problem.

[Anonymous]

Thanks Xifeng_L for your quick response.

Please note the SBU filters that I am talking about will not be constant for the pages, I mean that will vary from user to user. I have total 10 SBU in my model and which user can see what SBU I am getting that information from the RLS file. Do you still feel that adding filters to Calculation group will help here?

[xifeng_L · Accepted solution]

Sure, since you need to see different filter items on different pages, you can only use the manual simulation of RLS, it would be easier if use the calculated group.

Don't worry, filtering items will vary from user to user.