Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi Team,
I have a report with many subteams. Managers shouldn't see eachothers result, but they should see their own and those above in the reporting line. (Each manager should see company overall result, parent division result and own result.)
How can I solve this with RLS?
Thanks and regards,
Andrea
Hi @karpandi ,
It cannot be achieved through rls. The purpose of RLS is to limit users to only see the data that they have permission to see. Your requirement goes against it.
I also recommend you create an idea for it in https://ideas.powerbi.com/forums/265200-power-bi-ideas to improve the power bi.
Best Regards,
Dedmon Dai
Thank you for your reply. I was successful with setting up RLS with Organizational Hierarchy.
Unfortunately I couldn't find any solution for getting access to an overall result of the compnay or parent division without the possiblity of filtering (to other teams). Is there a solution for that?
Hi @karpandi
This can certainly be done.
Please look at this blog post by Reza Rad on how to achieve this: https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
User | Count |
---|---|
45 | |
26 | |
21 | |
18 | |
18 |
User | Count |
---|---|
52 | |
45 | |
24 | |
24 | |
21 |