8652
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

Desperate for this!!

P

This is a fantastic idea and echoes what I hear from many clients. Currently, we need to maintain 1 dataset and several report structures based on what people in the Org "should" see. A security structure to turn pages on or off based on role would be incredible.

P

This is a great idea. This would give us the ability to make certain pages show up for management, but not for the sales people, for example.
The sales team sees the sales data, the management see that and a page meters the sales people themselves.

P

I would also add the possibility to show or hide whole reports/dashboards in a particular workspace for certain roles

P

Let's make it happen Microsoft. I think this has been a request since 2016.

P

Also upvoted - I'm searching for a solution...

P

Following.

P

Follow. This is a must!

P

Following ..Its a must!!

P

It's function very helpful. Please consider to build this. Please advise me When You have any idea about security to show/hide ant page on a report.