Power Bi Service RLS Dynamic with adding Email Address

[bideveloper555]

hi

I did create RLS and it is working on Power bi Desktop.

but in my organisation ,more than 1000s of users name.

i am using USERPRINCIPALNAME ()  for RLS.

with out adding Email address(1000) time,is there any dynamic way, user can see the data as RLS Defined.

If user abc@test.com login, he should able to see his data as per RLS defined with out adding email address below?

If i add,it works perfect but i need to add 1000 and when new user turns up or user leaves, hard to keep track.

[bideveloper555]

this has been now fixed. i no longer need. thank you @lbendlin 

[LajwithSingh]

Hey How You Solved That Problem. 

[bideveloper555]

IF (

CALCULATE (

COUNTROWS ( 'StaffTable' ),

FILTER ( StaffTable, 'StaffTable'[Username] = USERPRINCIPALNAME () && [Admin] )

) > 0,

[Country]

= CALCULATE (

MAX ( 'StaffTable'[Country] ),

FILTER ( 'StaffTable', 'StaffTable'[Username] = USERPRINCIPALNAME () )

),

[Username] = USERPRINCIPALNAME ()

)

My table has admin bit flag. 1 has full access and 0 are restricted to allocation of the table.

ID	Name	Username	Admin	Country
1	John	john@email.com	0	UK
2	Peter	p@email.com	1	uk

[LajwithSingh]

Hi BiDeveloper555,

Can you Give Me More Details on the Same.

Like one Question I have Is Where you have put this Expression

Thankyou

[lbendlin · Accepted solution]

Use distribution lists.  Ideally manage these distribution lists in a separate application lifecycle tool, including ways for users to subscribe and renew membership,  with approvals and automatic cleanup when users leave the company.