Forum Discussion
RLS for Multiple Reports
So I have multiple datasources in a few different Sharepoint sites. I want to bring all these into one location and using the main table have them all connected in one place (Thinking of using one p...
The RLS will filter according to the relationships you have between your tables. You can test the roles, so make sure to do that...
If you need to grant the same access to all the reports, I would recommend using an Active Directory group and sharing it with the group (you can also apply the group to the RLS role), that way you can update members and it'll update everywhere it's used. You do need to share the reports to let them view it, or make an app and share the app with the group.