Page Level Security in Power BI || Hide and show pages based on user's permission

[@stephenrwafa2519]

Absolutely brilliant!! Thank you!

[@thebihub]

Glad it helped you!

[@aashishmeshram9892]

very helpful and informative video, keep making such good clips for those who want to know more from basic to pro level..

[@thebihub]

@@aashishmeshram9892 thanks aashish!

[@unnikrishnansanthosh]

good one, thank you for sharing

[@thebihub]

Thanks Santhosh!

[@Charanpro007]

Very much needed in current scenarios.

[@thebihub]

Yes, Thanks for sharing the knowledge boss!

[@tofonofo4606]

Very nice. Great info!

[@thebihub]

Thanks !

[@nitishranjan1716]

Hi @The BI Hub, Nee to Implement RLS to prevent some users from accessing Drillthrough in powerbi, kindly advise on same

[@diegoyglesias288]

What if an unauthorized user clicks on a shared link to a page that was not available? It will probably be able check the page, as it is not really hidden. I mean, this works but for very sensitive data I'm not sure is safe enough

[@thebihub]

Hi Diego, what you said is correct , to overcome this combine page level security with row level security so that if any unauthorised has a power bi url he can't see the data in visuals

[@pthapa55]

Nice information however you forgot to show the viewers how did you join all those tables that you created in the model.

[@thebihub]

Thanks, modelling is shown at the end of the video, please check!

[@pthapa55]

@@thebihub Thanks I see it now. I must have ended the video few seconds early.

[@thebihub]

@@pthapa55 no issues :)

[@vinodhinin568]

I want rls in report server.. Without publish the report. It is possible to set page level security in report server without the mail id with their gen id.

[@himanshusoni7618]

Nice work , can you share the Pbix file , you are not show the relationship or the tables

[@thebihub]

Thanks Himanshu, relationship is been shown in last 30 seconds!

[@himanshusoni7618]

​​@@thebihub , Thanks , there should be (one to many) relationships between PageList tables and PageAccessByRole table .. but in video it seems (Many to Many)

[@vinodhinin568]

In my home page have navigation to 7 different pages. When set row level security for only access to 2 pages. It showing only in slicer, but i can go to all pages

[@rajatdixit11]

You can hide all the pages and then publish. I think this might suffice.

[@bbcuevas]

I have done exactly the same example, and I get a message saying that the page does not exist or is not a valid destination. Let me know if you need any more help!

[@thebihub]

@@bbcuevas Hi, please check the page names are matching from the report and the initially created table

[@bbcuevas]

Hi, it’s been verified, and the name matches. I even copied and pasted it, and in the measure, I removed spaces at the beginning and end.

[@GaurangKadam-t2w]

@@bbcuevas I also came with same issue

[@bbcuevas]

I managed to make it work. I created a table for pages and another one for access roles, and it worked for me.

[@GaurangKadam-t2w]

@@bbcuevas Thanks bro, so i have createdPageaccess and UserAcces table it work with two table

[@munawarhussain1400]

What if user input another user email address to see hidden pages?

[@thebihub]

User can't put another person's email, power bi will automatically take the email of user logged in, impersonation has been done only to show the demo and can only be done by owner of the dashboard.

[@munawarhussain1400]

I have completed the setup. But still pages are not reflecting in BI online service. Not sure what I have done wrong. Can we have zoom call to discuss this?

[@thebihub]

@@munawarhussain1400 this Saturday please ping me here I'll share Google meet link