Can you do Page-Level Security in Power BI?

What's up with page-level security in Power BI? We keep getting questions from people about how to do this. I've got bad news and I've got... well, just watch the video!

Row-Level Security and Object-Level Security together in Power BI??? Yup!

Did you know you can now selectively show report pages for specific users in Power BI?


*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.


*******************
LET'S CONNECT!
*******************


***Gear***

#PowerBI #pagelevelsecurity #GuyInACube

[walteradamsbe]

Still waiting for page level security to be implemented for real in Power BI. This is most likely one of the most requested features for years.

[jdjr]

I literally just upvoted the page level security enhancement today at work. Thanks for the explanation and keep up the great work!

[jmwdba]

I just went through the pain of setting up a complex dynamic row level security today involving a list of individuals who could see specific information and a smaller list of individuals who could see everything regardless of who owns the information in the report. The one thing I wish Microsoft would do is allow you to display a message when a person doesn't have privileges to view information in a table instead of just showing an empty table.

[KateMikhailova]

For Power BI Report Server (on-premise) it works perfectly! No page-specific link is visible for user so I am planning to use this method. Thanks a lot Adam!

[unosleep]

I didn't know about the URL trick! Thanks! 👍

[andreacheck]

New word! And I also really appreciate this update... which is really nothing new, but still verifies there's no true page level security. This question keeps coming to us from newer Power BI developers in our org, so it is good to be able to verify it still isn't available.

[lucasshipsides]

you can mix RLS and OLS with field parameters to create single visuals that don't break when the user doesn't have access to all the columns, rather it only shows them the columns they have access to.

[uknsaunders]

I wish Microsoft would stop dicking around with features most users dont need and implement stuff like this! The fact you had to do a video on it is an acknowledgement its needed!

[denpries]

Also, users might be able to navigate through bookmarks, and if you set it up to jump to a page if not careful, they can simply go there still

[seanoloughlin]

The new App experience almost could work for this, since you can see the report pages it feels like a no brained to show and hide with audiences. The problem at the moment is hidden pages in the new apps are blocked, not just ‘hidden’ so this navigation wouldn’t work.

[cristianosecci]

I would think about creating a separate Drill-through (target) report for the pages to be secured, with the same styling of the Overview page. That target report can be of course secured properly (together with the centralized data model which would be serving both reports). Then you can use buttons (like shown in the video here) and the Drill-Through features from the Overview report to seamlessly drive your users back and forth, yet retaining a proper security over the "target" pages.

[calornix]

Thanks for your explanations, highly appreciated even if the video is a yeart out now, just came up with the usecase for page level security. For PBI Report Server the URL problem is not given, so works for me 🙂

[moritzde]

Also if you export to ppt pdf it would ask to include / exclude hidden pages.
Copy the report and then edit the copy could also bring up the hidden page.
Only thought I would have is to additionally secure the hidden page with a page level filter connected to RLS - but there is really no „secure“ way yet.

[NicholasEnslow]

Adam, not going to lie, this is what we thought we were getting with Multiple Audiences for a Power BI App. I'm all for having to code Object Level Security - just make the Page items Objects, and we can dynamically handle that with Rules 😀.

[pabeader]

Works fine in Report Server. URL is not all inclusive.

[lovenisarg]

@guyinacube can you provide the link for the page level security idea. I could not find it in the description.

[jontybuk]

Great video, when I spotted the URL with a page link this sparked my thoughts can I embed into a website on a certain page/tab in the report? I currently create a lot of separate reports to embed into our website but one report which would open on a certain tab with a URL would be a better option for me. Any thoughts on this?

[rohanwalker]

Very helpful. Would you possibly be able to share the 'selected page' measure that you mention is using 'conditional formatting' to drive the page navigation ? Many thanks

[JenMayB]

Is there a way to default the slicer setting to the row level security of the user? The values are the same?

[bhushanbangar]

I did a similar thing using chicklet slicer and button action to navigate to the page . But the problem with that is i need two clicks. One to select Page and second to navigate it.