topic Re: excel services access to external ODC files stored on PBIRS in Report Server

excel services access to external ODC files stored on PBIRS

Anonymous — Thu, 07 Jun 2018 11:40:28 GMT

I have Excel files stored on PBIRS along with their external .odc files. I have worked out how to construct and add URLs pointing to these .odc files on the PBIRS (using the new REST service /Resource endpoints). This works fine when the Excel file is opened on a local workstation. However, when the Excel file is opened in the PBIRS itself via OOS, we get an error about need a license to access .odc file. It is not clear if this is the real error. The question is: is there something we can do to allow Excel Services to access the .odc files via http on the PBIRS?

Re: excel services access to external ODC files stored on PBIRS

chrisfin — Thu, 07 Jun 2018 18:24:26 GMT

Unfortunately it's looking for a SharePoint license, since the only supported scenario for using .odc files are when their hosted and accessible from SharePoint server when using OOS.

Re: excel services access to external ODC files stored on PBIRS

Anonymous — Fri, 08 Jun 2018 09:34:45 GMT

It seems more complex than this. I get the same error if I store the .odc on Sharepoint and point the Excel files there. Also, I have some test files with the .odc on PBI server that work fine in the same OOS. The test that works uses an Oracle connection with saved username/password but the non-working ones use SSPI to SQL server, if that is relevant.

There are several online sources that say that this error is uninformative and means that the OOS needs upgrading.

Re: excel services access to external ODC files stored on PBIRS

Anonymous — Wed, 13 Jun 2018 12:24:34 GMT

An intermim solution is to have a central windows share containing the .odc files. This also works fine locally but OOS seems to have no way to refresh data when the .odc connection points to a share? It just shows the static data when last saved and there is no way of getting it to refresh in OOS?