Forum Discussion
Need Help - Control Page Navigation
- 1 year ago
You can follow this approach, I tested it and it will work
https://www.youtube.com/watch?v=FrEDZZXiit8
but remember there is a loop hole in this method, every time a person opens a specific page, reportSection id will appear in the report URL, so if one person shares that id to other person then users can easily by pass the page level security that you are trying to implement using RLS and DAX.
Connect on LinkedIn
Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos.
Proud to be a Super User!
- 1 year ago
Hey Manoj21011988 ,
Yes, I have faced this challenge before, and you are right Power BI does not currently support dynamic page-level security like it does for rows. A common workaround that works well within a single report:
- Use a landing page as your main navigation hub.
- Create navigation buttons (using shapes or buttons) to other pages.
- Control the visibility of these buttons using measures + selection pane.
Steps I Followed:
Create a DAX measure to check user identity:
ShowAdminPage = IF(USERPRINCIPALNAME() = "[email protected]", "Go to Admin Page", BLANK())
Use that measure in a card visual placed over the button and set transparency (or use bookmark workaround).
In the Selection Pane, toggle the visibility of the navigation buttons by layering a blocking shape/card that only appears for unauthorized users.
It's not true page-level security, but it’s a practical UI-driven method that works in many cases.
For Detailed Information:
Dynamic Navigation Based on User in Power BI – SQLBI
Create navigation experiences in reports – Microsoft Learn
Tips for Using USERPRINCIPALNAME in Power BI – RADACAD
Power BI Button Visibility Workaround Using DAX – Excelerator BI
Page Navigation Without Page Access – PowerBI Community Thread
If you found this solution helpful, please consider accepting it and giving it a kudos (Like) it’s greatly appreciated and helps others find the solution more easily.
Best Regards,
Nasif Azam
Page Level Security is not a thing. Create separate reports.