Row-level security (RLS) shows different rows of the same report to different people. A regional manager sees only their region, while the head office sees everything, without making a copy of the report.
How it works
- Create a role in Power BI Desktop, such as “North Manager”.
- Add a filter on the table, for example Region equals North.
- Publish the report, then assign people to each role in the Power BI service.
- Test each role with the View as option before you share the report.
Points to remember
- RLS limits what a viewer sees in the report, but it is not a replacement for a database permission.
- Test every role. A missing filter can show all rows to the wrong person.
- Keep the rule simple. One filter on one column is easier to check than many.
Build the basics first with the Power BI course overview, and read DAX basics. Book a free demo class, and ask a counsellor for batch details.
