8655
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

This "idea" was created over 5 years ago.
There are thousands of comments, that it's very useful.
So why is it still an idea "Under Review"?
In fact, not to offer this function should be handled as a bug!

P

A workaround is not a solution. Please make it happened

P

A button to navigate is often not a solution. If it is a one page report that few extra or less fields/visuals, we really need it to just load, especially if it is for access for top management or factory floor supervisors. They don't want to have the extra click. Just load the correct page.

P

when Microsoft will provide this feature ??
it"s definitely a MUST HAVE !!

P

We need a 'REAL' Page Level Security feature. I am pretty sure many people will love it.

P

We need this fix ASAP! @Microsoft

P

I have achieved this using RLS and Page navigation. I did the RLS for Product names in table then took same product as the Navigation. Now it shows only the products assigned to the particular users...

P

I hope that "Under Review" is a good sign.  This is a really important feature that I'm sure will be very popular.  The workaround that you posted is easily hackable.  When you're dealing with Sales people and commission info, security should be the priority.  In my report, I already have RLS security set up and only those salespeople assigned to certain regions can see their regions.  That's good.  However, there are pages that don't apply to them and it's a big issue having to create 2 separate reports.  That doubles the maintenance! 

P

What is so terribly hard about this? At a basic level, the only functional improvement that needs to be added is to enhance the Permissions model at the page level. This allows for the existing Report/App level permissions to remain, and within that permission scope each page can be assigned specific permissions, with the report/app level scope set as the default.



This doesn't require any changes to the existing RLS model, so that a page that has RLS continues to work as currently implemented.



This model would also keep the same security context whenever a report is exported to PPT, PDF or Analyzed in Excel.

 

P

Omar como solucionaste este tema?



Gracias





Leo A