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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.