Forum Discussion
RLS with Shared Dataset
Hi guys,
I have a question about handling RLS when using a shared dataset and two workspaces. I have two workspaces. The first workspace includes two dataflows (One getting data from SQL server and second from Excel), a dataset (shared dataset) and five reports. All of the reports are getting tables and calculations from the shared dataset. The first workspace doesn't have any row-level security, the users have access to everything in the reports.
The second workspace includes two reports and my thought was to get data from the shared dataset in the first workspace. But what should I do when reports in the second workspace need RLS and when I want to get data from the shared dataset?
Hope someone can help with my scenario 🙂
- That's what I was saying. One dataset. A role for Managers and that role can see everything. Then a role for Team members that can only see certain things. Create 2 reports off of that. The managers can see everything, the team members can only see their stuff regardless of which workspace they go to. Right?
7 Replies
- Greg_Deckler
Community Champion
Should work, RLS is report specific.
Greg_Deckler Can you explain how to do it? Because RLS need to be done on the dataset
- Greg_DecklerI guess I was making the assumption that you could create an ALL group and put the users that need to see everything in there and then create additional roles for the other users that should only see specific things in your second report.
Because it doesn't make any sense to me that you would have 2 reports with the same dataset and same users where in one they only need to see specific things and the other everything because they would just switch to the other report and see everything?