Forum Discussion
RLS with org hierarchy
Anonymous , if their reportees is part of if they should get access to it.
I think the MBAS Gallary video they have even shown how to bypass it for a certain user. Saw it long back so not sure now. Even you can have a fact where you do no apply RLS and give access to the executive from that
Thanks amitchandak
These are good reads on RLS.
I wanted to clarify 1 point.
If there are users - Mainly executives who are not part of the FACT data and if they need access to all the reporting, what is the usual practice? Is it better to NOT to add them to any roles?
I liked the dynamic approach narrated by Reza here - https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi. But, it kind of breaks if there are multiple managers for a user.
Anonymous , if their reportees is part of if they should get access to it.
I think the MBAS Gallary video they have even shown how to bypass it for a certain user. Saw it long back so not sure now. Even you can have a fact where you do no apply RLS and give access to the executive from that