cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MohanV Established Member
Established Member

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
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 @MohanV,

 

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
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 129 members 1,573 guests
Please welcome our newest community members: