UPN function not working correctly

[dirkmuis]

If I'm user the USERPRINCIPALNAME() on a gmail account I do get the msn.com# returned which should be part of the USERNAME() function. Is this a known issue or is the function broken?

With another domain (outside organisation) the UPN() works perfect.

[GilbertQ]

Hi there

I have found that even though that is displayed from the picker, if you are using RLS it will still use the actual email address

[dirkmuis]

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.

[v-yuta-msft]

@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.

[dirkmuis]

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?

[GilbertQ]

I do the same as you for gmail addresses

[dirkmuis]

I still need to put msn.com# in front

[GilbertQ]

That is correct yes

[dirkmuis]

So how do I know which will be the part in front as it is not always msn.com#........

[GilbertQ]

From what I have seen if the email address is to a @hotmail @outlook.com @live.com or @Gmail.com then the above will be put in the front.