Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Hi,
Here is how I've implemented a "page level security":
Requirements:
Solution:
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.
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
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
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:
ilgar@sample.com, Developer
qafur@sample.com, Manager
2. Create an RLS Role:
[Username] = USERNAME()
Read my Article: https://www.linkedin.com/pulse/row-level-security-azepowerbicommunity-gqs4e/?trackingId=fdsyEb0CQhib...
3. Create a Navigation Table:
4. Create a Navigation Button on Main Page:
ShowManagerPage = IF(SELECTEDVALUE(UserAccess[Role]) = "Manager", 1, 0)
5. Hide Sensitive Page:
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.
Page level security DOES NOT EXIST. Try not to waste your time. Use separate reports.