excel services access to external ODC files stored on PBIRS

[Anonymous]

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?

[Anonymous]

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?

[chrisfin]

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.

[Anonymous]

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.