Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |