https://community.fabric.microsoft.com/t5/Report-Server/When-I-upload-excel-workbooks-that-are-connected-to-Analysis/m-p/343058#M3531 <P>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.&nbsp; 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.&nbsp; It works fine for regular powerbi desktop reports but not excel.&nbsp; Is there a way to make this work when viewing excel reports on the Report Server.</P> Mon, 22 Jan 2018 21:26:41 GMT shera276 2018-01-22T21:26:41Z https://community.fabric.microsoft.com/t5/Report-Server/When-I-upload-excel-workbooks-that-are-connected-to-Analysis/m-p/343058#M3531 <P>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.&nbsp; 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.&nbsp; It works fine for regular powerbi desktop reports but not excel.&nbsp; Is there a way to make this work when viewing excel reports on the Report Server.</P> Mon, 22 Jan 2018 21:26:41 GMT https://community.fabric.microsoft.com/t5/Report-Server/When-I-upload-excel-workbooks-that-are-connected-to-Analysis/m-p/343058#M3531 shera276 2018-01-22T21:26:41Z https://community.fabric.microsoft.com/t5/Report-Server/When-I-upload-excel-workbooks-that-are-connected-to-Analysis/m-p/343187#M3534 How have you implemented RLS with Excel? How Office Online Server is connecting to SSAS? Tue, 23 Jan 2018 03:00:36 GMT https://community.fabric.microsoft.com/t5/Report-Server/When-I-upload-excel-workbooks-that-are-connected-to-Analysis/m-p/343187#M3534 pbx 2018-01-23T03:00:36Z https://community.fabric.microsoft.com/t5/Report-Server/When-I-upload-excel-workbooks-that-are-connected-to-Analysis/m-p/343784#M3547 <P>Hi <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="50630" data-lia-user-login="pbx" class="lia-mention lia-mention-user">pbx</a>&nbsp;- That's the thing, we haven't and not sure how to.&nbsp; We did implement it at the model/analysis server level.&nbsp; We use direct query to connect to Analysis Services.</P> Tue, 23 Jan 2018 17:21:37 GMT https://community.fabric.microsoft.com/t5/Report-Server/When-I-upload-excel-workbooks-that-are-connected-to-Analysis/m-p/343784#M3547 shera276 2018-01-23T17:21:37Z https://community.fabric.microsoft.com/t5/Report-Server/When-I-upload-excel-workbooks-that-are-connected-to-Analysis/m-p/343824#M3550 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.<BR />Hope this help. Tue, 23 Jan 2018 18:23:09 GMT https://community.fabric.microsoft.com/t5/Report-Server/When-I-upload-excel-workbooks-that-are-connected-to-Analysis/m-p/343824#M3550 pbx 2018-01-23T18:23:09Z