Enable different RLS for specific reports connected to a shared dataset
Hope you all are well.
All of our reports are referencing data from a shared dataset. The RLS is applied on this dataset and is working fine. Now, I have a requirement to create another RLS role and activate that role for only one report (ideally for visual). I have been working on that for a while now but I am not able to find a solution for it. Because adding a separate RLS role simply bypassing the existing role and effecting our existing reports.
Would you guys please help how can we activate a specific RLS for one report or ideally a visual only. I'd appreciate any help.