Hi All,
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.
Thank you!
@sm_talha , Create a measure using userprincipalname , that can filter data
and then use that is visual level filter, see if this approach can help
Thanks for the suggestion but I am sorry I think I am not getting what uou saying.
I have already applied a dynamic RLS which uses the userprincipalname and restricts data at organization's hierarchy levels.
I need to apply a similar RLS role, and that is actually bypassing the existing RLS.
User | Count |
---|---|
141 | |
60 | |
58 | |
58 | |
47 |
User | Count |
---|---|
135 | |
73 | |
58 | |
56 | |
51 |