I have a Sharepoint2013 (Enterprice) with excel services installed and power pivot with SQL SERVER 2012 R2 (Enterprice). In another physical server i have a SQL Server 2008 (Enterprice) and i have 14 OLAP Cubes, when i use Excel desktop i can connect to sql server Via power pivot but when i upload my excel to sharepoint and i try refresh conections i recive this error:
Error: An error occurred while working with the data model in the workbook. Retry.
You can not update one or more data connections in the workbook. Could not update connections:
SqlServer datos5 Logistica
Srry by my poor english.