Designing Dynamic RLS in Power BI: One Report, Many Users, Zero Data Leaks | Live Problem Solving Session

Hosted by: Harshit Doshi

Bootcamp Exclusive

Sat, 23 May 2026
06:00 PM - 07:30 PM IST

Online (Zoom)

Hosted by

Harshit Doshi

Senior BI Manager @ ASIC

Share With Friends

In most enterprises, a single Power BI report is consumed by dozens or even hundreds of users, but each one should only see the slice of data they are authorized to access. Building separate reports for every user group is not scalable, and static filters fall apart the moment the organization grows.

In this live problem-solving session, we'll design and implement a dynamic Row Level Security (RLS) model in Power BI, where each user logs in and automatically sees only the data they are entitled to, without a single line of report level filtering. The session is led by Harshit Doshi , Senior Manager Business Intelligence at ASIC and a BI Architect with 15+ years of experience building enterprise grade BI solutions.

What We'll Cover

✅ Understanding static vs dynamic RLS: when each approach makes sense in an enterprise setup

✅ Designing the security data model: user table, mapping tables, and role relationships

✅ Writing DAX expressions using USERPRINCIPALNAME() and LOOKUPVALUE() for dynamic filtering

✅ Configuring roles in Power BI Desktop and validating them with "View as Role"

✅ Handling edge cases: users with multiple access levels, hierarchies, and rollups

✅ Publishing to Power BI Service and mapping real users or AD groups to roles

✅ Testing RLS end to end from an actual end user's perspective

✅ Common pitfalls: bi directional relationships, ALL() functions, and broken security filters

Pre-Requisites / Pre-Read (Recommended, Not Mandatory)

Working knowledge of Power BI Desktop and basic report building
Familiarity with star schema and relationships between fact and dimension tables
Basic comfort with DAX functions like CALCULATE, FILTER, and LOOKUPVALUE
Awareness of what RLS is at a conceptual level (no prior implementation experience needed)