Forum Discussion
Row Level Security | Userprincipalname() for Guest Account
Have found my fail, just had wrong RLS Formula. "Userprincipalname()" instead of Userprincipalname() 😕
Anyway it's hard to understand where the "right" Userprincipalname() in Dataverse is saved or whether theres another name not saved in Dataverse.
Hi GilbertQ ,
I've created RLS Role with 3 options out of systemuser dataverse table:
- dominname (normaly = USERPRINCIPALNAME(), but for Guest Account something with #EXT)
- internalemail (just the normal emailadress)
- custom mail (Custom added column with mail# + email, cause its not in systemuser dataverse table available, but is showing in Power BI as USERPRINCIPALNAME())
Unfortunately my custom email column is not working although USERPRINCIPALNAME () is showing exactly the same and should be filtered in RLS.
BR,
Sven
Have found my fail, just had wrong RLS Formula. "Userprincipalname()" instead of Userprincipalname() 😕
Anyway it's hard to understand where the "right" Userprincipalname() in Dataverse is saved or whether theres another name not saved in Dataverse.