Dynamic RLS With Distribution List

[Anonymous]

Hello,

I have a report which shows all the ongoing projects. Access to the report is granted to distribution lists (i.e. zzz_global_projects), not to a single e-mail address. Inside this list, there are single users' e-mail addresses.

What I would like to have is each user from this distribution list is able to see only his projects. One of the columns in the project is "Project Leader", based on which the dynamic RLS should be set up.

This is the measure I have in the RLS for role ProjectLeader:

[Project Leader] = lookupvalue(ProjectLeadersRLS[Name In The Report],ProjectLeadersRLS[E-Mail],username())

1. Username() returns e-mail address.

2. These e-mail addresses are mapped in the flat table with the project leader name; for example, homer.simpson@fox.com will be mapped to Homer Simpson based on the above formula. And Homer Simpson is one of the Project Leader names that appear in the column Project Leader.

The challenge I have is that the above solution works for single users (if the access is granted for a single e-mail address), but probably not for the distribution list.

Does anyone know how to solve it?

thanks!

[v-eqin-msft · Accepted solution]

Hi @Anonymous ,

According to my understanding, you want to set RLS for groups,right?

To my knowledge, Distribution List group, Mail-enabled-security group and Security group could be added in below dialog

You could refer to this blog for further help.

See:

Row-level security (RLS) with Power BI

Create, edit, or delete a security group in the Office 365 admin center. 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.