Forum Discussion

raju8004212's avatar
raju8004212
Frequent Visitor
1 year ago
Solved

Dynamic Row level security

Hi Anonymous  dynamic swithcing of rls is  based on slicer selection rls logic working with out selection if we  include slicer selection  in rls its not wrking  my model is like bu_org ,snap co...
Need Help
  • v-sshirivolu's avatar
    v-sshirivolu
    11 months ago

    Hi raju8004212 ,
    To clarify it isn’t possible to pass slicer values or variables into RLS. Power BI always applies     RLS first (based on user identity), and only afterwards slicers/filters.

    That means a “toggle RLS by slicer” design isn’t supported. The only supported approaches are:

    Dynamic RLS using USERPRINCIPALNAME()  and a security mapping table.

    Report-level toggles (disconnected slicer + measures/filters) to switch between PU/HR views within the user’s authorized data.

    Separate roles/reports if different security contexts are mandatory.

    So the workarounds I shared earlier will help you simulate the toggle experience, but the true RLS logic can’t be driven by slicers.

v-sshirivolu's avatar
v-sshirivolu
Community Support
1 year ago

Hi raju8004212 ,

I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

 

v-sshirivolu's avatar
v-sshirivolu
Community Support
1 year ago

Hi raju8004212 ,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you