Forum Discussion
Dynamic RLS - multiple email formats for staff
I am setting up Dynamic RLS and planning to use the USERPRINCIPALNAME function. However, staff have emails used in outlook which are different than the emails used to share out reports. I want to confirm that I am choosing the correct email to set up the RLS with.
To sign into a Microsoft account and to share the report the email format is [email protected]. And the outlook emails are simply [email protected] . I assume I need to use the [email protected] emails for security.
My employee table has a column for each email format. I created the CSW_RLS role, and when testing 'View as' with either email type the data filters correctly if I specify what column to use as principal username. E.g., to filter using the locationlocal.ca email I have [Microsoft Email] = USERPRINCIPALNAME(). To filter using the location.ca email I have [Outlook Email] = USERPRINCIPALNAME().
How can I be sure which email format to set for the RLS?
- Anonymous2 years ago
Hi skygold16 ,thanks for the quick reply, you are right.
Hi Anonymous ,
As skygold16 said , the USERPRINCIPALNAME() function in Service returns the e-mail address you use to log in to Power BI Service.
3 Replies
- skygold16Helper II
Hi,
I think you need to always use the email address which end user will be using to login to Power BI service.
Thanks,
Harsh
- AnonymousNot applicable
Hi skygold16 ,thanks for the quick reply, you are right.
Hi Anonymous ,
As skygold16 said , the USERPRINCIPALNAME() function in Service returns the e-mail address you use to log in to Power BI Service.
- AnonymousNot applicable
Thank you both! That is what I assumed.