Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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#test@gmail.com. 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.
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 "test@gmail.com" which won't work. If I add msn.com#test@gmail.com it does.
Shoudn't the UPN() return test@gmail.com? And how will I know how everyone's gmail adres will be formatted like?
That is correct yes
So how do I know which will be the part in front as it is not always msn.com#........
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.