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
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

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!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors