Forum Discussion
Solved
Dynamic Row level security issue
Hi all, We are using Power BI Report Server. I am having some issues while implementing Dynamic Row Level security. The requirement is employees would need to see only thier related data in the das...
Thank you all for your replies.
I also tried using the below but this also didn't work.
[Email] = USERPRINCIPALNAME()
After much more investigation and google, got the below and used it and it seems to be working as expected.
[Login] == LOOKUPVALUE('Employeetable'[Login], 'Employeetable'[Email], USERPRINCIPALNAME())
Thanks all again for your inputs.
grkanth81.
Thank you all for your replies.
I also tried using the below but this also didn't work.
[Email] = USERPRINCIPALNAME()
After much more investigation and google, got the below and used it and it seems to be working as expected.
[Login] == LOOKUPVALUE('Employeetable'[Login], 'Employeetable'[Email], USERPRINCIPALNAME())
Thanks all again for your inputs.
grkanth81.