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
This blog is part of a longer series, which together comprise a full online training course in Power BI Service. You can see get details of our classsrom Power BI training courses here.
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.
- 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