RLS based on distribution list and security view

[blakeeno123]

Implementing RLS for the following scenario: 

I'm currently limiting project data based on a security table that has userprinciplename and project #. I join this to project table and create a role so that users only see projects that have access to. Something like this for the role: [upn] = upper(USERPRINCIPALNAME()). It works just fine BUT I also have a table that pulls names from a distribution list. If you're on this list, you should see all projects. So I need to figure out how to implement RLS to say that if you're in this distrubution list table, you see all projects. But if not, proceed with how I did it before where  [upn] = upper(USERPRINCIPALNAME()). Any ideas?

[marcelsmaglhaes]

Hey @blakeeno123 !

I think you can do something like this: Solved: RLS issue: how to enable some users to see all row... - Microsoft Power BI Community

If this post helps, please mark as solved. 

Kind Regards
Marcel

[blakeeno123 · Accepted solution]

Hi Marcel. Thanks for your feedback. I did get this to work but had to add a little more DAX code than just true/false but the true/false was incorporated into my solution so thanks.