Hierarchy view when implemented RLS

[Anonymous]

Hierarchy structure: Applied RLS

Name                Total

Manger             1000 

Supervisor1       500

Lead3                 250

Employee1         100

When we implement RLS on Hierarchy is it possible to see when Employee logsin, can able to view Grand Totals of Lead, Supervisor and Manger?

in the same case if Lead3 logsin can able to view Grand Totals of Supervisor and Manger?

Pleaes provide soluation.

[v-xiaotang · Accepted solution]

Hi @Anonymous 

Thanks for reaching out to us.

>>is it possible to see when Employee logsin, can able to view Grand Totals of Lead, Supervisor and Manger?

If employee and Lead, Supervisor and Manger are all at the same level, then when employee logs in, he can only see the data information belonging to the employee, but cannot see the grand total of Lead, Supervisor and Manger.

For example, when employee1 logins, the count of all rows = 6

FYI:

Restrict data access with row-level security (RLS) for Power BI Desktop - Power BI | Microsoft Docs

Dynamic Row Level Security with Organizational Hierarchy Power BI - RADACAD

Power BI Row-Level-Security Organizational Hierarchy – PBI Guy (pbi-guy.com)

Row Level Security With Hierarchies - YouTube

The above tutorials are suitable for beginners to learn RLS

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[GilbertQ]

Hi @Anonymous 

Here is an awesome blog post from Reza Rad on how to get this done

Dynamic Row Level Security with Manager Level Access in Power BI - RADACAD

[Anonymous]

Please provide soluation to reflect when Seals Rep Login, he/she should see grand totals of above level when implemented RLS?