Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
I have dynamic RLS set up in my dashboard.
The RLS model was working fine until I refreshed the dashboard recently.
The strange part is that RLS is working on USER_RLS_ENBDR part but not working on USER_RLS.
The set up is exactly the same.
User_RLS connected with VW_Role_Based_access using Work Email.
VW_Role_Based_Access is connected to Department_RLS using Reporting_Home_Dpt_CD
Department_RLS is connected to the values (Fact table) using department.
In the Manage security Roles, on department_RLS I have following:
[REPORTEE_HOME_DEPT_CD] IN SELECTCOLUMNS(
FILTER(
'VW_ROLE_BASED_ACCESS',
RELATED(User_RLS[WORK_EMAIL])=USERPRINCIPALNAME()
),
"Department_RLS"
,[REPORTEE_HOME_DEPT_CD]
)
On User_RLS and on VW_ROLE_BASED_ACCESS table, I have
[WORK_EMAIL] = USERPRINCIPALNAME()
Can anyone provide me with any suggestions or idea on how to fix this issue. Thanks
Can you provide some samples of what is in your columns exactly?
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 78 | |
| 48 | |
| 35 | |
| 31 | |
| 27 |