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.
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.
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).
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
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?
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?
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
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!
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?
Yes there is! It's called "Row Level Security" and I have a few videos covering this in case you're interested! ruclips.net/video/axTyP7I2Bso/видео.html
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?
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.
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
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?
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
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?
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??
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.
@@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.
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"
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?
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.
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.
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!
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).
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
I have been searching this for such a long time. A very very useful video. many thanks Fernan for your help...😃
Great !!! So clear and easy to follow. Brilliant work
Thank you Fernan, this is great and helped me perfectly!
Great job ! Your tricks are really very helpful.
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
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?
this is great, it works. thanks
Very good work! Very clear! Keep it up :) seriously man, good work.
Thank you so much for the video, this is very helpful for me :) keep up the good work new subscriber here
Thanks so much. This is really interesting but I'd like to know how to create the page access
Thank you so much!
You are the BEST!
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?
This is correct
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
Cleaver stuff. Thanks 💥
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!
did you find solution for this ?
Nice content, thanks!
Hi @Fernan ...Need to Implement RLS to prevent some users from accessing Drill through in powerbi, can you suggest on this
Excellent
Very helpful
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?
Yes there is! It's called "Row Level Security" and I have a few videos covering this in case you're interested! ruclips.net/video/axTyP7I2Bso/видео.html
Hey, um awesome work behind, I just need to know the method to get page no. into column
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?
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.
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
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?
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
Hi there, yes unfortunately this will be the case
I cannot select column "Page" as Field Value for the arrow button. Why is that?
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?
2019 v of what???
How was the Page Table created to understand each report page? I did not get that part :(
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??
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 ?
How the power bi understands page 1 in table value is same as the name of the page
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.
What if John exports this report ? Will he still see hidden pages in the export ?
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.
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?
disregard
How to add multiple users in the table
Can we add AD groups in place of user IDs ? Will that work too?
Hi! Just wondering if you found a solution to your question? I’m also stuck with this problem at the moment.
@@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.
@@ananyaverma6046 Thank you so much. I've been researching for a solution. I will let you know if I get lucky!
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"
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?
its old version
I expect some more info...
😴