Forum Discussion
UPN function not working correctly
I tried with an @gmail.com and with an @somethingelse.com.
The @somethingelse.com does return the e-mail adress.
The @gmail.com does return the UN() so e.g. msn.com#[email protected]. I've no idea where the MSN part is coming from? That must be because the gmail has been registered at microsoft for using with powerBI.
dirkmuis ,
Yes, the external email account will be changed temporarily. You can ignore them when you build dynamic RLS, creating a column using original gmail can work well.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I don't understand.
My DAX looks like this:
[ID beroepsgroep] IN SELECTCOLUMNS( FILTER( 'tblBIuserprofgroup', RELATED(tblBIUser[tblBIUsername])=USERPRINCIPALNAME() ),"tblprofgroupid" ,[tblprofgroupid] )
The user table contains in tblBIUsername the value "[email protected]" which won't work. If I add msn.com#[email protected] it does.
Shoudn't the UPN() return [email protected]? And how will I know how everyone's gmail adres will be formatted like?
