Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreWe've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
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
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.