cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
laikittmun
Frequent Visitor

Row level security is not working in Analyze in Excel

Hi,

 

I have a dataset that with RLS Roles and rules defined at the Power BI desktop and publish to the service. After that I have assign users/groups to the Roles that available in the datasets. The RLS is working when users run the report against the dataset. However, the RLS is not working then do Analyze in Excel for that dataset. Could anyone advise which part I should fix to make this working. 

The users that I tested with the Analyze in Excel are Contributor and Viewer. The workspaces are in premium capacity. 

 

 

6 REPLIES 6
tombrox
New Member

Watching... I have the same problem. Okay i PBI Service - not in Excel. User is Viewer on workspace.

laikittmun
Frequent Visitor

For my understanding, the RLS should work in the Analyze in Excel for VIewer. But it is not right now!  Could anyone advise which part that I should look into to figure out where went wrong ?

Hi, @laikittmun 

Yes , the RLS should work in both report and Analyze in Excel for Viewer. 

If RLS works on PowerBI Service, it should also work when do Analyze in Excel for that dataset. 

Please recheck the account you used for tested with the Analyze in Excel.

 

Best Regards,
Community Support Team _ Eason

Check your data model. Make sure there are no arrows pointing to the RLS table.

lbendlin
Super User
Super User

RLS does not work for Contributor roles. Only test with viewers.

But for Viewer , the RLS should work in both report and Analyze in Excel right ?

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors