Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

RLS based on distribution list and security view

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?

  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

2 Replies