RLS in PowerBI

[Anonymous]

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

[Anonymous]

Question has been updated!

[Anonymous · Accepted solution]

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