RLS doesn't work for direct reports when user principal name is different to email address

[creedrulz]

Hi ,

I have created a RLS role called "direct report" which filters the currently logged-in user data as well as his direct reports.

var current_logged_in =

LOOKUPVALUE(dim_IvmsOperator[IVMSOperator_SK],dim_IvmsOperator[OperatorEmailAddress],USERPRINCIPALNAME())

return
PATHCONTAINS(dim_IvmsOperator[Emp_Path],current_logged_in)

The issues arise when the user's principal name is different from the email address. 

our company standard email is firstname.lastname@xyx.com  which is aligned with the user principal name for most cases but there are exceptions that have different user principal names such as Paul.J.Rodd@xyz.com instead Paul.Rodd@xyz.com. Apparently, there were quite a few. Does anyone know a workaround for this issue? Any help is greatly appreciated .

Thanks,

Dee

[creedrulz]

@amitchandak 

the data is already there and pulled from a dimension table in sql called dim_oprator which has what you mentioned (i.e email , operator id , leader id  user names etc)

[creedrulz]

does anyone have come across any instance as such? still trying to figure out a workaround.

[amitchandak]

@creedrulz , Better to have a table which takes care of this

example

email1, email , dept