Forum Discussion
Have more than one RLS role for each user in a Shared Data Set
Hi,
I have a Shared Data Set (SDS) that many reports get their data from. Is it possible to allow a user to see all data in one report, but only some data in other reports? E.g.
Report 1 is a Country summary so I'm happy for everyone to see all the data for all the state.
Report 2 is a State report with very detail info, so I only want each State Manager to view data for their own state.
Both these reports get their data from the same SDS. Is it possible to give a user 2 different roles, and the relevant role works depending on the report? How would you go about this?
Thank you!
abloor
This is not possible, RLS is used to limit the access to dataset not reports. For your requirement, you may only create 2 workspaces and assigned the users to both workspaces with corresponding rls roles.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
2 Replies
abloor
This is not possible, RLS is used to limit the access to dataset not reports. For your requirement, you may only create 2 workspaces and assigned the users to both workspaces with corresponding rls roles.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.you may want to read this article Row-Level Security on a DirectQuery to Power BI dataset composite model: My Findings - RADACAD
