How to handle multiple roles using RLS

[Anonymous]

Hello All,

I have created a report for the PM level.

I have created a role as PM in desktop and used USENAME() dax funciton and i have published thos report to the serivce level.

There i have added respective people who have access to this report.

And it is working fine.

Currently i have created only single role that is PM.

But now i have another 2 senarions.

1:-- For some people this report should be filtered by the SBU wise. 

At PM level the projects will be filtered by the peoject list which a perticular PM is having under his list.

But there are some users, for them the same report shoud be filtered as

all the projects which the perticular user belongs to the perticular SBU.

2:--- For some peopel this report should be filtered by the DM level.

like as PM, how the project are getting filtered.

For DM also it should be filtered all the projects under him.

A-->PM--> PID-1,PID-2 PID-3

B-->PM--> PID-4,PID-5 PID-6

C--> DM--> under him A and B PM's are there.  So here the project list should be

        PID-1,PID-2 PID-3,PID-4,PID-5 PID-6

Is it possible with current powerbi RLS.

Any suggestions.

Thanks,

Mohan V

[v-qiuyu-msft]

---

Currently i have created only single role that is PM.

But now i have another 2 senarions.

1:-- For some people this report should be filtered by the SBU wise. 

At PM level the projects will be filtered by the peoject list which a perticular PM is having under his list.

But there are some users, for them the same report shoud be filtered as

all the projects which the perticular user belongs to the perticular SBU.

2:--- For some peopel this report should be filtered by the DM level.

like as PM, how the project are getting filtered.

For DM also it should be filtered all the projects under him.

A-->PM--> PID-1,PID-2 PID-3

B-->PM--> PID-4,PID-5 PID-6

C--> DM--> under him A and B PM's are there.  So here the project list should be

        PID-1,PID-2 PID-3,PID-4,PID-5 PID-6

---

Hi @Anonymous,

Would you please share some sample data and show us which row you want the PM to view? 

Best Regards,
Qiuyun Yu