cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 227 members 2,564 guests
Please welcome our newest community members: