Adding row-level security to Power BI reports
Part one of a four-part series of blogs

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!

  1. Securing Power BI Reports and Dashboards (this blog)
  2. Row-level security in Power BI Desktop
  3. Row-level security in Power BI Service
  4. Who can see what in your reports

This blog is part of a much 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:

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
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.

This blog has 0 threads Add post