All work / 03

HR Row-Level Security

Demo built on dummy data. Not client work.

A demo services company with 1,200 people and 36 teams. There is one report and one RLS role; a permissions table decides which teams each person sees, so a new manager is a new row, not a new report.

Five test users were checked with View as in Power BI Desktop, and each one matched the test matrix.

Inside the report

HR Row-Level Security, 1
HR Row-Level Security, 2
HR Row-Level Security, 3

Same report, two users

Report author, no role applied
Report author, no role applied
Viewed as manager01: one team only
Viewed as manager01: one team only