RLS based on many columns

Hi Jacob_  I believe I have created something similar to what you are asking for.

I have a large group of employees that can only see their data.

A small group of managers that can only see their direct report’s data.

A medium size group of people that can see everything.

First step was creating an Excel file that lists all of the employees that are only allowed to see their own data.  This table included their name, territory, and email address (You could create this table within Power BI but in my case the file is maintained by another department, so I created it in Excel).  Then I created a role for these people with a filter applied to only show data where “ [Email Address] = userprincipalname() ”

For the managers,  I created a role for each manager and applied a filter where the territory column on the bridge table equals their territory.

For those that can see everything, I created a role that had no filters applied. This step is technically not required as anyone granted permission to the report will see everything unless they are in a RLS role,  but I wanted an easy way to see who had the “see all” role so I went this route.

Once the report was published, I added the appropriate employees to the new roles.

Hope this helps! Let me know if you have questions.