8653
Add security to show/hide any specific page (Tab) on a report based on users privileges / Roles.
Attachments: MergeStatus.txt (0.20KB) MergeStatus.txt (0.18KB) MergeStatus.txt (0.18KB) MergeStatus.txt (0.19KB) MergeStatus.txt (0.19KB)
STATUS DETAILS
Under Review

Thanks for all the feedback! Currently, Power BI does not have a security feature for pages; however, using conditional page navigation and RLS, you can create a custom navigation experience that shows different page options for different roles.

Here's an example of this custom navigation experience: 
 Navigate with a Go button

You can start by hiding all pages on your report except the landing page. Then you will create a column that contains the exact names of the pages in report.
Here's an example: 
Create a table

Using Power BI's row-level security feature, you can define the security roles and rules for this column, and then you can add the column to a single-select slicer.
The slicer will only show values in the column based on the security roles and rules that you've applied to this column.
Navigate slicer

Next, you can create a page navigation button and click the fx button to conditionally format the destination based on the column: 
Page navigation button
 
Now the button can navigate the user to the selected page:
Navigate with a Go button

 

Comments

P

Agree entirely with a bunch of the comments. We have pages that are designed to be used as drill through only. Over time we have had to make a bunch of changes to cater for people browsing and wanting to filter in other ways.

The other use case is where we are developing pages in a report while also maintaining other pages - so managing multiple pbix files is equally as bad as publishing half finished pages. Hiding the unfinished pages could be one solution, otherwise role based security on seeing a page or even just a checkbox to choose which pages to actually publish.

P

This would be a fantastic addition to go with the new drill-through feature. Please look into this!

P

Pleaaaaaaaseeeeeeeeeeeeee!!!

P

We really need this functionality. Can we get a comment from Microsoft if it is in the works?

P

This would be a huge win and I could see how this would work well with drillthrough

P

Agreed. Also hiding sheets which can still be accessed via the drillthrough feature would be very helpful. Some pages are now designed only to be drilled in to, and should not be able to be opened without using this feature.

P

Desperately need this to control the number of reports i have to create to limit information accessible by user. Very annoying as I like to have one report for particular analysis and then have each tab filtered by a county.

Alternatively, would be great to share just the dashboard and nothing behind the dashboard.

P

This is definitely a must, for only developing and maintaining one report and offer personalized views to the different roles. RLS is just not enough and managing X reports for X different roles, so everyone only sees what they must, can be a nightmare.

P

Definitely need this capability - presently workspace level access, dashboard access exists and data security. There is an area between what is available today which are Report Level (PBIX), Report Page Level, Dataset and Data Gateway which are important to have full governance and access control.

P

This feature is really a must in power Bi