How to Implement PAGE-LEVEL SECURITY to hide and show pages based on Permissions // Power BI Guide

[@adammilescpa]

Fernan, thank you for this excellent video! Tip to anyone with an error after publishing - If you cannot get this to work when you publish to the PBI service, you might need to refresh the dataset.

[@gopyjs6216]

Hi Fernan, I'm happy to tell you that today I joined as a data Analyst(PBI Developer role). Thanks for your wonderful videos. I learned many things from your videos.

[@SolutionsAbroad]

Great job Gopy! I'm really happy for you, my videos helped but ultimately it was your hard work that made it happen so well done!

[@limecows]

This is awesome. I've been looking for something like this. Like other commenters have said, this isn't fool proof so I wouldn't use it as your only security measure, but this combined with other row level security could meet security needs plus a great user experience. (depending on the application and data sensitivity of course).

[@SolutionsAbroad]

Yes absolutely! I realise my flaw was not disclosing how secure this method is, purely because it's a workaround to a feature that doesn't exist... yet

[@shubhabratadey]

I have been searching this for such a long time. A very very useful video. many thanks Fernan for your help...😃

[@lexunajinrui1340]

Great !!! So clear and easy to follow. Brilliant work

[@user-cc3in2gp9g]

Thank you Fernan, this is great and helped me perfectly!

[@Shubhamkr-i3o]

Great job ! Your tricks are really very helpful.

[@johnbasha8561]

this is great, it works. thanks

[@zuzuburi6985]

You are the BEST!

[@davidpenan3780]

Thanks so much. This is really interesting but I'd like to know how to create the page access

[@supriyakarkera4647]

Hi Fernan, really a great video. I have followed al steps from the video with a 10 page Powerbi report. However; my end user can't see the page slicer to select the pages. Can you please guide what could be the issue?

[@dominikspieler5308]

Thank you so much!

[@ralphnebruconcepcion8055]

Thank you so much for the video, this is very helpful for me :) keep up the good work new subscriber here

[@newnorm2023]

Very good work! Very clear! Keep it up :) seriously man, good work.

[@Parkwaydriver]

Nice content, thanks!

[@ArifulIslam-gs6uy]

Excellent

[@abirayari7338]

Is there any other way to navigate through the pages with one click instead of creating a list and a button? Thank you in advance

[@nitishranjan1716]

Hi @Fernan ...Need to Implement RLS to prevent some users from accessing Drill through in powerbi, can you suggest on this

[@Ocram-gnuhc]

Very helpful

[@spen2431]

Cleaver stuff. Thanks 💥

[@deepdeep-yy2pt]

Hey, um awesome work behind, I just need to know the method to get page no. into column

[@christianblasing9304]

Hi Fernan, thank you very much for the great video. We have created a start page in each of our reports on which the (hidden) report pages are shown as thumbnails and the thumbnails have a link to the report pages. That is for our user a very easy way to select the report page they would like to see. Do you see a possibility to design the links behind the thumbnails dynamically, based on the page security model, instead of using the filter?

[@sureshb3881]

Thanks for the detailed explanation on page level security. In my case, only one page is assigned to one user. I want users directly go to the assigned page instead of going for home page and clicking on the button. Is this possible? Thanks once again!

[@DhananJayShembekar]

did you find solution for this ?

[@dillonfarrar4634]

Hey Fernan, Is there anyway to implement something similar but instead of every user starting on Page 1, they start on the first page defined in the page access table? I am attempting to avoid a "home" table or "page 1". Preferably the report opens up on the tab in the report that the Page Access Table defines.

[@SolutionsAbroad]

Hmm great question, I don't think so. As of now, the only workaround I know is to have a "home" page that everyone can access, and then have the page-level security applied from the selection there

[@AbhishekBajajAU]

Hi, thanks for the video! Is there a way to actually hide some particular data from different users? So basically limiting people from accessing all the data?

[@SolutionsAbroad]

Yes there is! It's called "Row Level Security" and I have a few videos covering this in case you're interested! kzbin.info/www/bejne/l6m3qoNtfpd1qdE

[@sofokhvedelidze8923]

Thank u.BuT if i send the Page1 link to the user who doesn’t have access to the Page 1 , She will see the page1… when it comes to link, this approach doesn’t work🥹 any suggestions??

[@techtips2398]

It is not full proof as someone who has access to a certain page can share the link to that page with someone who doesn't have access and it will still work. But unfortunately this is our only option. Am I wrong?

[@limecows]

This is correct

[@SolutionsAbroad]

Yes that is absolutely correct, unfortunately its a workaround to a feature that doesn't exist. I would recommend if the data is sensitive in nature is to use Row Level or even Object-Level security

[@gagandeepsinghmalhotra6133]

Hello, Video time -13.58, explains about security for RLS and adding users for accessing the hidden RLS pages, but this has restricted other users to see the Page 1, do u have a solution for the same. Thank you in advance.

[@davidignatius1]

I cannot select column "Page" as Field Value for the arrow button. Why is that?

[@finlaybatts7946]

Hi Fernan! Really enjoyed this video! I have a question about exporting from PowerBI - does this security function also limit the pages that can be exported by a certain user?

[@faridhussain3281]

Created a button but the option of Page Navigation in Action Type is missing. I am using 2019 version. Because of organizational coordination and refresh issue, I am bound to work on 2019 version. Is there any way to use Page navigation option in Action type for button in 2019 version? Is there any other solution except upgrading the version?

[@mirrrvelll5164]

2019 v of what???

[@ritikpankaj2302]

Is it possible that I can share page 1 to ABC person only and page 2 to XYZ only the rest can see all pages ?

[@paragkhandalkar]

If you download the report in power point then there we have option to also download the hidden pages.there i think they can still access the non authorised pages. Can you confirm this

[@SolutionsAbroad]

Hi there, yes unfortunately this will be the case

[@ytbytb7531]

What if the entire organization (hundreds of people) needs to have acces to certain pages?

[@vikasshivaprasad8758]

Hello, I have changed the page names and hwo do I link them up now? The page may not exist or invalid destination is the error I am getting.

[@bypolion]

How was the Page Table created to understand each report page? I did not get that part :(

[@PhanindraGaddam-kt3hz]

What if John exports this report ? Will he still see hidden pages in the export ?

[@figuresovertrend8416]

How the power bi understands page 1 in table value is same as the name of the page

[@scottst_3324]

in your video you show a metric titled "page" which appears to be the name of the tab/page in PBI. How did you create this?

[@scottst_3324]

disregard

[@trivenigaikwad3899]

How to add multiple users in the table

[@ananyaverma6046]

Can we add AD groups in place of user IDs ? Will that work too?

[@mikkim1023]

Hi! Just wondering if you found a solution to your question? I’m also stuck with this problem at the moment.

[@ananyaverma6046]

@@mikkim1023 no i haven't. I tried using AD group but this method doesn't work for AD groups. I am clueless since it is really difficult for clients to mantain an Excel file for user access.

[@mikkim1023]

@@ananyaverma6046 Thank you so much. I've been researching for a solution. I will let you know if I get lucky!

[@PhlySports]

This will work, but you will need to query your AD for the user's group based on their logon (or maintain manually which is not recommended). You can query AD for the list of users for a specific AD group which requires access. Then your join table is ADGroup and Page instead of Email and Page. let // This query retrieves the list of users in the specified AD group which is used to determine if user is part of group allowed to see all data Source = ActiveDirectory.Domains(pmDomainName), Domain = Source{[Domain=pmDomainName]}[#"Object Categories"], group1 = Domain{[Category="group"]}[Objects], #"Removed Other Columns" = Table.SelectColumns(group1,{"securityPrincipal", "group"}), #"Expanded securityPrincipal" = Table.ExpandRecordColumn(#"Removed Other Columns", "securityPrincipal", {"sAMAccountName"}, {"ADGroup"}), #"Filtered Rows" = Table.SelectRows(#"Expanded securityPrincipal", each Text.Contains([ADGroup],pmADGroupExec)), #"Expanded group" = Table.ExpandRecordColumn(#"Filtered Rows", "group", {"member"}, {"group.member"}), #"Expanded group.member" = Table.ExpandListColumn(#"Expanded group", "group.member"), #"Expanded group.member.name" = Table.ExpandRecordColumn(#"Expanded group.member", "group.member", {"name", "mail"}, {"NAME", "EMAIL"}) in #"Expanded group.member.name"

[@mihaelkyoleyan1543]

Hi I have a PBI report with a lot of hidden pages and the navigation to them is done via bookmarks (Some pages have pop up menus, switch between quarter/month so I can't actually do page navigation as a button action, instead I use bookmarks) I tried setting it up like described in the video however the bookmark takes me to the restricted pages.. is there any workaround apart from creating a separate pbix and giving access to it to selected individuals?

[@djenral6153]

its old version I expect some more info... 😴