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! Learn more

Reply
PowerbiQue
New Member

Row level security not working from excel

I have created a SSAS tabular model.

Implemented rowlevel security using DAX, created roles as required. Used USERNAME()/UserPrincipalName() to filter data for row level security.

 

It works as expected when connecting to from PowerBI.

Row level security not working from excel when conencting to Tabular Model. when I connect to Analysis services tabular model using excel it brings up all the data.

 

5 REPLIES 5
VijayP
Super User
Super User

@PowerbiQue 

Unfortunately Excel doesn't support RLS




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


VijayP
Super User
Super User

@PowerbiQue 

in excel it will not work !




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


how about connecting to dataset from Excel, will that work?

VijayP
Super User
Super User

@PowerbiQue 

you mean you want use RLS in Excel? question is unclear




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


I have implemented rowlevel security on SSAS Tabular model (Azure instance).
When I access the dataset from PowerBI it is working as ewxpected.

When I access the Tabular model from Excel, Rowlevel securiy is not working

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.

Top Solution Authors