Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to Solution.
Used the below and it worked
[Email1] = left(USERPRINCIPALNAME(),find("@",USERPRINCIPALNAME())-1)
Question has been updated!
Used the below and it worked
[Email1] = left(USERPRINCIPALNAME(),find("@",USERPRINCIPALNAME())-1)