Forum Discussion
UPN function not working correctly
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 d...
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?
