RLS for Single Page

[datauser_2025]

Hello. I am building a multi-page report for a team that includes an individual contributor scorecard. The team should be able to see everything on all the pages except the scorecard page - that should be limited to only their own data. However, when I apply the RLS, it breaks the other pages. 

Does anyone have a solution for this? Thanks!

[Anonymous · Accepted solution]

Hi, @datauser_2025 

Thank you very much for joining us on the Fabric forum.

I guess you could consider making your scorecard system a separate report and publishing it to the Report server(SSRS) or Power BI Service(Power bi report builder), and this sub-report will apply RLS to make sure that everyone only has access to the data that they have access to. Then insert this subreport into the main report. This way, your other pages won't be affected.

Subreports in Power BI paginated reports - Power BI | Microsoft Learn

For Power BI report builder:

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.