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 a DAX code in the role to show only the ID from the email address and not the entire email address as my security model is based on ID.

Can someone please help me with the DAX code here.

 

Thank you

Poojitha

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

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

2 Replies

  • 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)