topic Re: How to implement the page level filter in a report. in Developer

How to implement the page level filter in a report.

SaikumarV — Mon, 07 Jul 2025 16:50:00 GMT

how to hide a filter page from a report where developer can see 3 pages but manager can see all pages from the report.How to implement this power bi

Re: How to implement the page level filter in a report.

lbendlin — Mon, 07 Jul 2025 20:45:40 GMT

Page level security DOES NOT EXIST. Try not to waste your time. Use separate reports.

Re: How to implement the page level filter in a report.

Ilgar_Zarbali — Sun, 13 Jul 2025 07:08:32 GMT

To show/hide pages based on user roles like Developer vs. Manager, use page navigation with RLS logic, because Power BI does not natively support page-level security.

Steps to Implement:

1. Create a Role Column in a Table:

Example: UserAccess table with columns: Username, Role
Add rows like:

ilgar@sample.com, Developer
qafur@sample.com, Manager

2. Create an RLS Role:

Go to Modeling → Manage Roles
Use DAX:

[Username] = USERNAME()

Read my Article: https://www.linkedin.com/pulse/row-level-security-azepowerbicommunity-gqs4e/?trackingId=fdsyEb0CQhibpWlRSOMeUg%3D%3D

3. Create a Navigation Table:

List your page names: "Main", "Manager Page", etc.

4. Create a Navigation Button on Main Page:

Use conditional formatting to show/hide buttons or use a slicer-driven navigation logic:

ShowManagerPage = IF(SELECTEDVALUE(UserAccess[Role]) = "Manager", 1, 0)

5. Hide Sensitive Page:

Remove direct access via tabs.
Add buttons only visible to Manager role to navigate to the restricted page.
Use Bookmarks + Selection Pane to manage visibility.

This way, Managers can access all pages, but Developers won’t see buttons leading to restricted content — even though pages technically still exist in the report.

Re: How to implement the page level filter in a report.

v-prasare — Tue, 15 Jul 2025 06:34:09 GMT

We would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.

@Ilgar_Zarbali, @lbendlin Thanks for your prompt response

Thanks,

Prashanth Are

MS Fabric community support

Re: How to implement the page level filter in a report.

v-prasare — Mon, 21 Jul 2025 10:17:53 GMT

Hi @SaikumarV,

We would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.

Thanks,

Prashanth Are

MS Fabric community support

Re: How to implement the page level filter in a report.

v-prasare — Thu, 24 Jul 2025 17:38:04 GMT

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

If we don’t hear back, we’ll go ahead and close this thread. For any further discussions or questions, please start a new thread in the Microsoft Fabric Community Forum we’ll be happy to assist.
Thank you for being part of the Microsoft Fabric Community.

Re: How to implement the page level filter in a report.

dani-k — Thu, 24 Jul 2025 20:44:58 GMT

Hi,

Here is how I've implemented a "page level security":

Requirements:

Two groups of users: Group 1 can see all the pages + page A / Group 2 can see all the pages +page B (instead of A)

Solution:

Create a new table (in power query) "Pages" with one column "Page" and insert two rows, with the exact names of the pages ("Page A", "Page B")
Create 2 functions:
1. Page A, where column Page = "Page A"
2. Page B, where column Page = "Page B"
Hide the pages A and B
Insert a button to navigate to your desired page (A or B), based or the logged user, button action = page navigation, using function Field Value, "First Page", First.
After publishing you report, go to the RLS settings and set up your users according to their permissions