cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shera276 Regular Visitor
Regular Visitor

When I upload excel workbooks that are connected to Analysis Services RLS doesn't work

Hi - With the October release of PBI Desktop and Report Server, you are allowed to upload excel workbooks and run queries connected to Analysis Services.  This is great! We have RLS implemented but when viewing the report in excel on Report Server, it's not working, i.e. everyone can see the same data.  It works fine for regular powerbi desktop reports but not excel.  Is there a way to make this work when viewing excel reports on the Report Server.

3 REPLIES 3
pbx Member
Member

Re: When I upload excel workbooks that are connected to Analysis Services RLS doesn't work

How have you implemented RLS with Excel? How Office Online Server is connecting to SSAS?
shera276 Regular Visitor
Regular Visitor

Re: When I upload excel workbooks that are connected to Analysis Services RLS doesn't work

Hi @pbx - That's the thing, we haven't and not sure how to.  We did implement it at the model/analysis server level.  We use direct query to connect to Analysis Services.

pbx Member
Member

Re: When I upload excel workbooks that are connected to Analysis Services RLS doesn't work

I assume you have a SSAS model that depending on who connects shows them what they have access to. Now when you put an Excel file connected to that model on PBI RS, and assuming you have configured integration of PBI RS and Office Online Server, the Excel will render in the portal through OOS when someone clicks on it. If the spreadsheet that was loaded contains data, it will be shown to the users. The SSAS security model will kick in, only when you refresh. In normal Excel you can force a pivot table to refresh when a file is opened, but not sure if that can be forced in OOS. Now when the user refreshes, your infrastructure should pass the credentials from PBI RS portal to SSAS. You have two options, the difficult way, Kerberos configuration, the easy way, configuring Excel service of OOS to use effective username. If I were you, I would go with the Kerberos way.
Hope this help.

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)