Forum Discussion
menphis21
3 years agoHelper IV
Insert a condition on the managing role RLS
Hi,
i have a table with all the data about the hours that each employee reports each month.
I have a hierarchy with user, his counselour, team leader etc
But i want that the counselor can see his team and also himself in the data so its means that i need to write in the managing role something like
[Counselor Email]= Userprincipalname() or [User Email]= Userprincipalname()
How can i do it ?
Thank you 🙂
2 Replies
- amitchandakSuper User
menphis21 , refer if this can help
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
- PadycosmosSolution Sage
I hope this video might help:
https://www.youtube.com/watch?v=0OPcZeLHbfY&list=PLApPcvU5-R24K3mbxORV7T3ckVLfDjmHF&index=24