cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

How to handle multiple roles using RLS

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

 

1 REPLY 1
Highlighted
Moderator v-qiuyu-msft
Moderator

Re: How to handle multiple roles using RLS


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 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors