page level security

Hi Anonymous  You can’t reliably use measures for dynamic page navigation in Power BI Service, as it often breaks after refresh. Instead, use bookmarks and the selection pane to show/hide page content based on roles. Implement Row-Level Security (RLS) to filter data per user and control visibility within pages.

can you create a sample and share the powerbi file. i have totally 16 pages. for admin has to access all pages for users need to access the page which we give access

Hi Anonymous , Thank you for reaching out to the Microsoft Community Forum.

In Power BI, Page Level Security is not possible directly. But there are a few workarounds to do this. 

Avoid using DAX measures for page navigation. These are unreliable in the Power BI Service and often fail after refresh. Instead, use a single landing page with buttons, bookmarks and Row-Level Security (RLS) to control access and visibility. Start by connecting to your Excel file stored in SharePoint. The data should include columns like Team, Email, Role, and Page1 through Page16, with TRUE/FALSE values indicating access. You can add a calculated column for display if needed. For example:

Page1_Status = IF(Sheet1[Page1] = "TRUE", "Control In-Scope", "ABC")

In Power BI Desktop, define Row-Level Security by navigating to Modeling -> Manage Roles. Create two roles: one for Admin, where you set the filter as [Role] = "admin" to grant full access to all data and another for Manager, using [Email] = USERPRINCIPALNAME() to ensure each user only sees the data associated with their own email.

On your report, create a single “Main Page” with 16 buttons labeled “Page 1” through “Page 16”. For each logical page, group the visuals using the Selection Pane. Then create bookmarks like Show_Page1, each showing one visual group and hiding the others. Assign each button an Action -> Bookmark, linking it to the correct bookmark. To control which buttons appear for each user, create DAX measures for visibility. For example:

CanAccessPage1 =

CALCULATE(

    COUNTROWS(Sheet1),

    Sheet1[Email] = USERPRINCIPALNAME(),

    Sheet1[Page1] = "TRUE"

) > 0

Repeat for each page. Then, for each button, go to Format -> General -> Properties -> Visible -> fx and bind it to the corresponding measure. This way, users only see buttons for pages they’re authorized to access. Test this using the “View as” feature in Power BI Desktop. Admins like [email protected] should see all buttons, while managers like [email protected] should only see the pages they've been granted access to. After publishing to the Power BI Service, go to Dataset -> Security and assign users to the correct roles. Optionally, you can personalize the experience by showing a welcome message using:

WelcomeMessage = "Welcome, " & CALCULATE(MAX(Sheet1[Role]), Sheet1[Email] = USERPRINCIPALNAME())

If this helped solve the issue, please consider marking it “Accept as Solution” and giving a ‘Kudos’ so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.

Hi Anonymous ,
I wanted to follow up and see if you’ve had a chance to review the information provided here.
If any of the responses helped solve your issue, please consider marking it "Accept as Solution" and giving it a 'Kudos' to help others easily find it.
Let me know if you have any further questions!

Hi Anonymous , I hope you're doing well! Just checking in to see if you had a chance to review the details shared earlier. If any of the information addressed your needs, feel free to mark it as "Accept as Solution"  to help others in the community. Please let me know if you have any further questions!

my solution is working fine 

thanks for help 

Regards 

In this case, if  user knows the URL of the admin user, they can access right ? at the end of the URL we will have report ID, right ?