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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
ThomasWeppler
Super User
Super User

Checking if row level security works

Hi Power Bi Community

I have added this row level security: 
[Afdelingschef email] = userprincipalname()

It works exactly as it should which is great, but I cannot see which user can see what data.
When I type a mail addrese into the desktop version it shows all the data no matter what e-mail it is.
When I type the e-mail into the service I see no data for some reason.
I use this guide to check if the user has acces: https://docs.microsoft.com/en-us/power-bi/enterprise/service-admin-rls


All help is appreciated.

1 ACCEPTED SOLUTION
ibarrau
Super User
Super User

Hi Thomas. Are you selecting both check boxes when testing? you must check "Other User" inserting the email and the name of the RLS rule. Both of them together should filter the data model with that rule.

I hope that helps,


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

View solution in original post

2 REPLIES 2
ibarrau
Super User
Super User

Hi Thomas. Are you selecting both check boxes when testing? you must check "Other User" inserting the email and the name of the RLS rule. Both of them together should filter the data model with that rule.

I hope that helps,


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

Thanks @ibarrau 
That worked.

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.