Restrict Access to a page when working with thousands of changing users

[Bethany123]

Hi,

I have a report with various pages that a whole company has access to (thousends). However I have one page that I want to resrict access to (to just a handful of people). This is a differnt dataset but the requirement is that its still in the same report. 

Is there anyway of doing this without using RLS where I have to input all user emails (which constantly change with starters and leavers).

Thanks

Beth

[Anonymous · Accepted solution]

Hi @Bethany123 ,

According to your description, it seems that you want page-level limit to access, right?

I'm afraid currently there's no feature in power bi, you can vote for this idea.

As a workaroud, it is suggeted to use following two solutions:

1. Break the report into two set of reports: one with open access and another with “secure” pages. Share the report with the secure pages with the people who can access it or publish it to a separate workspace.
2. Add a hidden page-level or report-level slicer that filters on a DAX measure. The DAX measure can check the user identity using the USERPRINCIPALNAME() function, so the slicer doesn’t return any values if the interactive user is not authorized. Granted, a better (and preferred) way to achieve this could be to apply RLS but RLS will restrict data to all visuals where as a slicer can filter only selected visuals.

Reference: Securing Power BI Report Pages

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[manikumar34]

@Bethany123 , 

Is that page should be aaccessed with Starters and Leavers basis??