Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join 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.

Reply
kfaiyaz
Regular Visitor

Dynamic Row Level Security model is not working after refreshing the dashboard

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


kfaiyaz_0-1697747140696.png

 



1 REPLY 1
Brunner_BI
Super User
Super User

Can you provide some samples of what is in your columns exactly?

------------------------------------
Brunner BI focusing on Microsoft Power BI development and consulting
Developers of external tool "Measure Killer"
My blog

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.