Forum Discussion
Row-level Security to Multiple Reports with Same Dataset
Thank you all!! Although this solution could work, it is not feasible due to the creation of workareas... Finally, I am going to create copies of the reports filtered to each zone (there are 4 zone values, therefore 4 copies of the report), and will be given access as appropriate
Super UserHey bcdobbs ,
this approach requires that users do not have build permission on the underlying dataset.
Regards,
Tom
Community ChampionNo I'm sure the RLS kicks in on the disconnected table even with build permissions as long as user not higher than a viewer in workspace with build permissions directly granted to dataset.
If the user were to build their own report they could choose whether to turn the calc group on or off and filter the rest of the report but the RLS is still active.
- bcdobbs
You could also do something along these lines:
https://www.sqlbi.com/articles/implement-non-visual-totals-with-power-bi-security-roles/
- TomMartens
Hey Ben,
sure RLS will kick in, but with build permission on the dataset, a user can create his own reports using PBI Desktop creating his own measures without the need for using the disconnected table and the calculation group.
From my point of view RLS should always prevent users from seeing what they should not.Tom
- bcdobbs
Ok see what you mean. My reading of the question was that there was a need to use RLS to change user interaction rather than using it for security specifically.