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
  • Anonymous's avatar
    Anonymous
    1 year 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.

Mo_d2's avatar
Mo_d2
Regular Visitor
9 months ago

Research Assistance: Expert Survey on Visual Analytics Security and RLS Challenges (12 minutes)

Greetings to our valued Power BI experts,

I am [Mohamed Fawaz Ismail], and I am conducting a specialized study on "Visual Analytics Security" (Secure Visual Analytics). The study aims to identify the actual gaps and risks that developers and analysts face when dealing with sensitive data within dashboards (particularly in relation to RLS, encryption, and Access Control).

Your practical experience in designing and securing dashboards using Power BI is the foundation for the success of this study. Your opinion on questions related to:

Applying the Least Privilege Access principle.

Dealing with accidental data leaks.

The importance of auditing and monitoring (Logging & Auditing).

...It will help us formulate better security standards for the community.

Duration: only about 12 minutes.

Survey link: [https://docs.google.com/forms/d/e/1FAIpQLScUNJwYADW3zyv8HcX4Js8xsLClet4NyogKoYHwanJ4kbY0ww/viewform?usp=header]

Please take a few minutes to participate. I would be happy to share a summary of the results with you later.

Thank you very much for your time and cooperation.

[Mohamed Fawaz Ismail]