Forum Discussion
Helper IShare Report with Branch Filter for each Branch Manager
Hi,
I am working on a Report that needs to be shared with 15 Branch Manager, each Manager can only see their Branch Data. is there any other way instead of creating 15 Reports. Thanks
Hey heygau ,
use Row Level Security (RLS), which will allow the use of a single semantic model and a single report.
If you are not familiar with RLS I recommend that you create 15 roles, configure the branch as a filter for each role and then assign the branch managers to the corresponding roles. This provides you with an introduction to RLS: Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn
Keep in mind, that you have to share the report with the branch managers using a Power BI app, do not assign the branch managers to the workspace directly. This will provide an introduction to Power BI Apps: https://learn.microsoft.com/en-us/power-bi/consumer/end-user-apps?WT.mc_id=DP-MVP-5003068
Hopefully, this helps to tackle your challenge.
Regards,
Tom
1 Reply
- TomMartens
Super User
Hey heygau ,
use Row Level Security (RLS), which will allow the use of a single semantic model and a single report.
If you are not familiar with RLS I recommend that you create 15 roles, configure the branch as a filter for each role and then assign the branch managers to the corresponding roles. This provides you with an introduction to RLS: Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn
Keep in mind, that you have to share the report with the branch managers using a Power BI app, do not assign the branch managers to the workspace directly. This will provide an introduction to Power BI Apps: https://learn.microsoft.com/en-us/power-bi/consumer/end-user-apps?WT.mc_id=DP-MVP-5003068
Hopefully, this helps to tackle your challenge.
Regards,
Tom