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

Поделиться
HTML-код
  • Опубликовано: 16 янв 2025

Комментарии • 36

  • @unnikrishnansanthosh
    @unnikrishnansanthosh 7 месяцев назад +1

    good one, thank you for sharing

    • @thebihub
      @thebihub  7 месяцев назад

      Thanks Santhosh!

  • @stephenrwafa2519
    @stephenrwafa2519 2 месяца назад +1

    Absolutely brilliant!! Thank you!

    • @thebihub
      @thebihub  2 месяца назад

      Glad it helped you!

  • @aashishmeshram9892
    @aashishmeshram9892 6 месяцев назад +1

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

    • @thebihub
      @thebihub  6 месяцев назад

      @@aashishmeshram9892 thanks aashish!

  • @r.ivanpadillao.5236
    @r.ivanpadillao.5236 Месяц назад

    Awesome, thanks for the information very clear 👍...

  • @Charanpro007
    @Charanpro007 7 месяцев назад +1

    Very much needed in current scenarios.

    • @thebihub
      @thebihub  7 месяцев назад +1

      Yes, Thanks for sharing the knowledge boss!

  • @tofonofo4606
    @tofonofo4606 6 месяцев назад +1

    Very nice. Great info!

    • @thebihub
      @thebihub  6 месяцев назад +1

      Thanks !

  • @prachikanoongo1221
    @prachikanoongo1221 15 дней назад

    How can we apply both Row Level and Page Level Security

  • @bbcuevas
    @bbcuevas 2 месяца назад +1

    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
      @thebihub  2 месяца назад

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

    • @bbcuevas
      @bbcuevas 2 месяца назад

      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
      @GaurangKadam-t2w 2 месяца назад

      @@bbcuevas I also came with same issue

    • @bbcuevas
      @bbcuevas 2 месяца назад

      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
      @GaurangKadam-t2w 2 месяца назад

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

  • @nitishranjan1716
    @nitishranjan1716 4 месяца назад

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

  • @diegoyglesias288
    @diegoyglesias288 4 месяца назад +1

    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
      @thebihub  4 месяца назад +1

      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

  • @munawarhussain1400
    @munawarhussain1400 6 месяцев назад +1

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

    • @thebihub
      @thebihub  6 месяцев назад

      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
      @munawarhussain1400 6 месяцев назад +1

      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
      @thebihub  6 месяцев назад

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

  • @vinodhinin568
    @vinodhinin568 7 месяцев назад

    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.

  • @pthapa55
    @pthapa55 5 месяцев назад +1

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

    • @thebihub
      @thebihub  5 месяцев назад +1

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

    • @pthapa55
      @pthapa55 5 месяцев назад +1

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

    • @thebihub
      @thebihub  5 месяцев назад

      @@pthapa55 no issues :)

  • @himanshusoni7618
    @himanshusoni7618 6 месяцев назад +1

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

    • @thebihub
      @thebihub  6 месяцев назад

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

    • @himanshusoni7618
      @himanshusoni7618 6 месяцев назад

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

  • @vinodhinin568
    @vinodhinin568 7 месяцев назад

    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
      @rajatdixit11 6 месяцев назад

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