topic Re: Excel online on OOS server, excel renders but is unable to change slicers. in Report Server

Excel online on OOS server, excel renders but is unable to change slicers.

Anonymous — Mon, 04 Dec 2017 13:15:35 GMT

Im am getting error, "The workbook attempts to utilize ODC File to connect to a data source. You are not licensed to use this feature"

The excel file i am rendering in pbi report server with oos server installed on the same machine runs normally with all slicers and filters in excel desktop. however when it has been uploaded to the pbi report server the mentioned error is displayed. Other Excel files give me this error "External Data Refresh Failed, An error occorred during an attempt to establish a connection......"

All these excel files are connected to an ssas cubes. I also have a few pbi reports rendering inside the same pbi report server and they do not have any issues regarding filters and slicers.

Re: Excel online on OOS server, excel renders but is unable to change slicers.

v-qiuyu-msft — Tue, 05 Dec 2017 10:00:14 GMT

Hi @Anonymous,

Please make sure you download and install the latest Power BI report server version here: https://www.microsoft.com/en-us/download/details.aspx?id=56137

Verify you already followed this article to complish all steps: https://docs.microsoft.com/en-us/power-bi/report-server/excel-oos#limitations-and-considerations

Best Regards,
Qiuyun Yu

Re: Excel online on OOS server, excel renders but is unable to change slicers.

Anonymous — Tue, 05 Dec 2017 12:58:37 GMT

Thx @v-qiuyu-msft I have made sure of that. Both PBI Report server and PBI SSRS are on the same version. I followed those instruction to the letter, ran all those PowerShell scripts in admin mode.

Before there was an 2010 office pack installed on this maschine. I uninstalled it before installing the oos server. Everything else works, the server is responsive using http://server/hosting/discovery . and the Pbi live query reports are rendering normally.

The same user is logged on the machine, and it has admin privilage. both excel files and pbi reports are connected to cubes (ssas) running on an enterprice sql version on a another machine.

Re: Excel online on OOS server, excel renders but is unable to change slicers.

Anonymous — Wed, 27 Dec 2017 16:06:36 GMT

The solution is to set the oos farm (computer running the oos server) with admin privilage on the SSAS server. Excel can not use .ods files. connection to database from excel must be with a connection string.

as is detailed here:

Connecting Excel to Data with SharePoint 2016 and Office Online Server 2016

Re: Excel online on OOS server, excel renders but is unable to change slicers.

koenverbeeck — Thu, 08 Mar 2018 23:04:53 GMT

I gave the machine adminstrator rights in SSAS and I made sure there's no ODC file in the Excel workbook (the type is OLAP query), but I still get the same error. Is it a licensing issue?

Re: Excel online on OOS server, excel renders but is unable to change slicers.

Anonymous — Mon, 12 Mar 2018 08:45:19 GMT

SQL must be an enterprice version or version 13 and above (2016).

Re: Excel online on OOS server, excel renders but is unable to change slicers.

koenverbeeck — Mon, 12 Mar 2018 08:58:17 GMT

I have SQL Server 2017 Enterprise. PBI Report Server was also the lastest version.

Turns out the OOS was out-of-date; installing the latest version solved the issue.