Forum Discussion
Dynamic RLS for organisational hierarchy using path for multiple managers
Yes, that's the gist of the discussion here. You can go the hard route, trying to implement that logic with static RLS and multiple roles, or you could go the simple route with dynamic RLS and a precomputed access matrix.
This may help: Managing hierarchical organizations in Power BI security roles - SQLBI
Thank you for your reply but I'm more concerned about the logic aspect of how to roll up the sales data of sales rep to multiple managers. Right now I'm able to roll up only to one manager using the path function. Can you please share your insights for this scenario?
Also coming to RLS, the requirement is to filter the report based on hierarchy and not on a special role. For example, if a manager logs into the report, he or she should have access to his or her's data along with their subordinates data. Thanks!
Yes, that's the gist of the discussion here. You can go the hard route, trying to implement that logic with static RLS and multiple roles, or you could go the simple route with dynamic RLS and a precomputed access matrix.
This may help: Managing hierarchical organizations in Power BI security roles - SQLBI