Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Prakash04
Regular Visitor

Dynamics RLS

Hello Experts,

 

I have a requirement as when my manager logs into the Power BI report then he would like to see only the direct people reporting to him.

 

How can we achieve this scenario?

 

Below is the list of employees in the group.

 

Prakash04_0-1659722721197.png

If Sam logs in then he would like to see all the resources reporting to him as given below for reference.

 

Prakash04_1-1659722735971.png

 

Could you please share me link/youtube videos for reference?

 

Thank you in advance!

 

Regards,

Prakash 

1 ACCEPTED SOLUTION
marcelsmaglhaes
Super User
Super User

Hey @Prakash04 ,

 

 First of all, you need create a new table with the data of the managers (name, id, email). After that, you should related the Manager with the table Emp (that have the data about employees). I use the name of the manager on the Manager table and related with the Reporting in the Emp table.

Then you create your dinamic RLS. Check the images. 😃

 

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

 

Kind Regards,
Marcel Magalhães

marcelsmaglhaes_1-1659731212681.png

Content of Manager table (the email field will be the key to the dinamic RLS)

marcelsmaglhaes_2-1659731238244.png

Create the RLS on tab Manager on field 'email'

marcelsmaglhaes_3-1659731328236.png

 

Applying  the test (pay attention in the visual. All people are list)

marcelsmaglhaes_4-1659731399536.png

Just viewing the SAM team

marcelsmaglhaes_5-1659731470227.png

 

 

 

 

 


Regards,
Marcel Magalhães
Microsoft Power BI Official Partner
MCT | Certified PL-300 Power BI

If I've helped, don't forget to give Kudos and mark my post as a solution!
Imagem de fundo



View solution in original post

2 REPLIES 2
marcelsmaglhaes
Super User
Super User

Hey @Prakash04 ,

 

 First of all, you need create a new table with the data of the managers (name, id, email). After that, you should related the Manager with the table Emp (that have the data about employees). I use the name of the manager on the Manager table and related with the Reporting in the Emp table.

Then you create your dinamic RLS. Check the images. 😃

 

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

 

Kind Regards,
Marcel Magalhães

marcelsmaglhaes_1-1659731212681.png

Content of Manager table (the email field will be the key to the dinamic RLS)

marcelsmaglhaes_2-1659731238244.png

Create the RLS on tab Manager on field 'email'

marcelsmaglhaes_3-1659731328236.png

 

Applying  the test (pay attention in the visual. All people are list)

marcelsmaglhaes_4-1659731399536.png

Just viewing the SAM team

marcelsmaglhaes_5-1659731470227.png

 

 

 

 

 


Regards,
Marcel Magalhães
Microsoft Power BI Official Partner
MCT | Certified PL-300 Power BI

If I've helped, don't forget to give Kudos and mark my post as a solution!
Imagem de fundo



nvprasad
Solution Sage
Solution Sage

Hi,

 

You can do this by preparing data which supports your need. You should have table with Employee Name and their direct reporting employees (1st level managers) and use this table for RLS .

 

I have done similar to this 2020. So data preparation is key here.

 

Appreciate a Kudos! ‌‌
If this helps and resolves the issue, please mark it as a Solution! ‌‌

Regards,
N V Durga Prasad

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.