BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
To prevent the wrong people seeing the wrong data in your reports, you can create row-level security (for example, so only the London regional manager can see London data). This blog explains how!
- Securing Power BI Reports and Dashboards (this blog)
- Row-level security in Power BI Desktop
- Row-level security in Power BI Service
- Who can see what in your reports
Posted by Andy Brown on 08 July 2017
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
Securing Power BI Reports and Dashboards
This blog series shows how to protect the following simple example chart:
This chart shows courses attended in 3 venues. Should you be inspired to recreate this, you can download the PBIX file and SQL Server script to generate the tables here.
This company has two regional managers: North and South. Here's the chart each should see:
|Southern manager||Northern manager|
The blog will show setting row-level security (RLS) in Power BI Desktop, then go on to show how this applies in Power BI Service.