Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
melanieruiz
Regular Visitor

Using different roles to filter pages within a report

I'm buidling a report with multiple pages and I'm wanting to apply different roles to the different pages.

 

The two roles would be Employee and Mentor, but would both pick up the username() of the person logged in. The first page in the report would use the Employee role to show data related to the person. The second page would use the Mentor role to show data related to the person's mentees.  

 

Is this possible? I really don't want to have to build separate reports for every person.

1 ACCEPTED SOLUTION

@melanieruiz

AFAIK, there's no page level security as you described, one has access to a report can view all pages. I think you submit your idea at Power BI Ideas and vote it up.

View solution in original post

4 REPLIES 4
JillianK
Regular Visitor

People have been asking for this for 7 years. I don't know that voting for this feature will help at this point, but it certainly can't hurt: https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=2dd57d8f-9e1e-4eb0-8dd1-05a566e522cf

Eric_Zhang
Employee
Employee

@melanieruiz

May I know what is your purpose? I think maybe you can use Row Leve Security in Power BI?

As mentioned, I'm trying to filter the different pages of a single report based on different roles.

 

When a person logs in I want to pick up their username. The first page would filter on Employee=username to show data related to the person. The second page would need to filter on Mentor=username to show data related to the person's mentees. As far as I can tell, only 1 role from RLS can apply to a report, not to the individual pages within the report. I believe I'm going to have to make separate reports instead of pages within one report. 

@melanieruiz

AFAIK, there's no page level security as you described, one has access to a report can view all pages. I think you submit your idea at Power BI Ideas and vote it up.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.