Forum Discussion

datauser_2025's avatar
datauser_2025
Regular Visitor
1 year ago
Solved

RLS for Single Page

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 shou...
RLS
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.