Page Level Security

[piyushjain0304]

Hi Everyone,

Let me give you a little context first:

We have created 2 Power apps which are integrated with Power BI and 2 Report pages in a single PBIX file. There are 4 set of users(4 departments in a company) which will access to the particular app or report page. Suppose, one user will have access to 1 app and 2 reports and other will have access to only 2 reports.(The roles are defined). 

Now,

The main problem is that we have to send the pbix file to our client which publishes the file by changing the data source.It will cumbersome for our client to publish 4 different pbix files with row level security applied in each pbix files. Is there any way that we can do all of this in one pbix? 

[V-lianl-msft]

Hi @piyushjain0304 ,

Based on your description, you could learn more about Dynamic Row Level Security

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

[henrychr]

You cannot set RLS per page, the RLS roles are applied to the PBIX as a whole. The only possible way I can think of doing it is if the two pages/tabs use distinct tables with no relationships, then you could then set RLS on each table independently. That wouldn't stop unauthorized users from seeing the second tab, only they'd see a bunch of visuals with errors indicating insufficient access rights.

[piyushjain0304]

Hi henrychr,

Thanks for the reply..!!

But I am not looking for row level security. Row level security is already applied in the pbix file. There are 4 tabs (2 Powerapps Integrated and 2 Report pages) and all the pages are bookmarked and hidden so that they can be accessed through a landing page(Using icons). 

What I need is that 4 icons that are used for these 4 tabs should be dynamically be accessible to the end user. for eg. one user cannot use 1 tab and can see all other tabs or one user can see only 2 tabs.

[henrychr]

@piyushjain0304 understand what you're looking for; User A can see Tab 1 and 2, User B can see tabs 3 and 4.

That level of security doesn't exist in PBI. You cannot hide tabs based on user roles.

There's an Idea posted where you can vote on it: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/16059178-page-tab-level-security

[piyushjain0304]

Thanks...!! It was of great help.

[mustafaasiroglu]

Hello,

You can create tab(page) level security by conditional navigation feature coming with May 2020 release of Power BI. 

I wroted details about this workaround here: https://www.linkedin.com/pulse/page-tab-level-security-conditional-navigation-power-bi-a%25C5%259F%2...