Live.com# is added to external email for Outlook when RLS security enabled

[Anonymous]

hi

i have bunch of external users sitting on different external domains and i need to share the reports with them and apply the RLS at the report level . I have the cretaed the table with bunch of related columns along with email . Ex: a@outlook.com . I have the creared the dax in below to cpature the email :[userEmail] = USERPRINCIPALNAME(). But this is giving the live.com#a@outlook.com as shown in below screenshot . can anyone help how to tacle this in DAX?.

One  more question is will live.com# is constant across all other domains?

[v-chuncz-msft · Accepted solution]

@Anonymous 

You may take a look at the post below.

https://community.powerbi.com/t5/Service/USERNAME-returning-weird-e-mail-format/m-p/545032#M55780