Dynamic RLS - see all if a certain user

[anthony_dobson]

I am trying to achieve the following using dynamic RLS:

1- regular user can only see data for their UPN

2- certain special users can see data for all users (these users are listed in another table: UserSecurity)

[userprincipalname] =
VAR UPN = userprincipalname()
VAR ViewAllAuth = LOOKUPVALUE('UserSecurity'[userprincipalname],'UserSecurity'[userprincipalname],UPN)
RETURN IF(ISBLANK(ViewAllAuth), UPN)

Currently the above returns just relevant data for regular users, but the special users can only see data for the few hundred blank UPNs, and not all 10k users. How to correct this DAX to return all for the special users?

[amitchandak]

@anthony_dobson , Refer if this can help https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchies

[parry2k · Accepted solution]

@anthony_dobson I have blog post on RLS that talk about how to implement your business logic in RLS and I believe that will help you to implement it.

Read it here.