Two RLS on same table

[poojag820]

I have 2 sheets in one report. 

Sheet 1 is built entirely from table A. 

Sheet 2 is built from table A and table B. ( tabular view with metrics combined from table A and B)

Now the requirement is when user 1 logs in and go to sheet 1, he should be able to see data corresponding to specific country and Unit 1 and when same user 1 go to sheet 2, then he should be able to see data corresponding to specific country and Unit 2. 

I am using composite key for storing data corresponding to users like User 1 - composite key (country&Unit1) for sheet 1

and User 1 - composite Key (country&Unit2) for sheet 2. 

Challenge here is that how do I apply two RLS on same table. 

Any help is much appreciated. 

[Anonymous · Accepted solution]

Hi @poojag820 

Thank you very much lbendlin for your prompt reply. Allow me to share something.

“TableA”

“TableB”

“Sheet1”

“Sheet2”

Manage roles

Save and publish to the Power BI Service.

Go to Semantic model in the Power BI service.

Under Security, assign the user's mail to Role_Sheet1.

When A user accesses Sheet 1, he will see data in Table A with Country = "India" and Unit = "Unit1".

  

When A user accesses Sheet 2, he will see data in Table A and Table B with Country = "India" and Unit = "Unit2"

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Your RLS table lists all allowed composite keys for that employee.  It controls the fact table in a *:* single direction link.