RLS for names available in column

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

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 [email protected] 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