Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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? 

  • Anonymous's avatar
    Anonymous
    2 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

  • 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

  • Anonymous's avatar
    Anonymous
    Not 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.

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    Thank you both! That is what I assumed.