Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

RLS in PowerBI

Hi All,  I have a RLS built in Power BI where I have created a role to get the current user email address. As the username() brings in the email addresss in Power BI service, I need to write ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Used the below and it worked
    [Email1] = left(USERPRINCIPALNAME(),find("@",USERPRINCIPALNAME())-1)

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Question has been updated!

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Used the below and it worked
    [Email1] = left(USERPRINCIPALNAME(),find("@",USERPRINCIPALNAME())-1)