How to map the 2 email ids of an individual in the row level security in the PBI service?

[ShivangiPatil]

Hi @marcorusso ,

There is a scenario where I am trying to use Row level security for one of my reports. For a particular domain, for an individual, there are two kinds of microsoft emails which are generated/ accepted. For example - PIV01 and pernille.iversen are the emails which directs to a single person's mail.  However, it becomes difficult for the system to understand and thus, it shows no data to the user, when it lands on the report from their mailbox. Is there a way we can somehow map both the emails for the user ? 

Can we somehow make the system understand that its the same person, in the RLS?

marcorusso 

[Anonymous]

Hi  @ShivangiPatil ,

You can try to create a group in the admin center to correspond to a role, put all users belonging to this role in this group, and set this group to role.

In this way, in a new report that uses dynamic RLS requirements, you can directly use group to set the role, instead of setting the user to the role one by one again.

What is Power BI administration? - Power BI | Microsoft Learn

If the users you join are outside the organization, you can also use planned invitations to turn accounts of different organizations into guest users, and then pull them into the workspace, see this report.

Distribute content to external guest users with Azure AD B2B - Power BI | Microsoft Learn

Best Regards,

Liu Yang

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

[ShivangiPatil]

I wonder, this wasn't the case. 

I am trying to reference to the mapping functionality which I believe was present earlier for the emails (similar emails but different domain, of an individual) in the service, which could be setup as the rule , for the system to understand that it's the same individual and can be granted access in the row-level security for the report.

Can we think of a way in which we can somehow setup a rule where we specify that -  PIV01 and pernille.iversen  is the same person , having access and make them the data visible in the report?

@marcorusso