RLS for names available in column

[ghouse_peer]

Hi Team

I need your help for below requirement.

I have 2 Columns

Leadership and Manager.

Leadership	Manager
ABC	EWQ
ABC	ERT
XYZ	JKL
CDE	LKJ
CDE	OKM
QWE	LPO
TUV	UNM
RFV	KJH
MNB	TGB

Leadership contains 7 Unique names of Leadership

Manager column contains 12 unique names of manager belonging to respective Leadership.

Now i need to provide RLS for respective leadership and managers. Whenever they login or access the report they need to see only there reports.

ex: if XYZ from leadership is accessing report then he need to see only his reports and his manger's report who is under him.

Kindly help with solution. Thanks in advance

[Anonymous · Accepted solution]

Hi @ghouse_peer ,

Based on your description, this involves concepts related to dynamic RLS. You can do this with username and userprinciplename, but you need to be aware of their differences:
In Power BI Desktop, username() will return the user in DOMAIN\User format and userprincipalname() will return the user in user@contoso.com format.
In Power BI Services, both username() and userprincipalname() will return the user's User Principal Name (UPN). This looks similar to an e-mail address.

Refer to the following screenshot:

after publish to the service, test RLS

Also, you can refer to below document:

Row-level security (RLS) with Power BI - Power BI | Microsoft Learn

Dynamic Row Level Security with Power BI Made Simple - RADACAD

Best Regards,
Adamk Kong

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

[Ritaf1983]

Hi @ghouse_peer 
Please refer to the linked tutorial

https://www.youtube.com/watch?v=c1P3W3xJl_4&t=2s

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