Symptoms
Assume that you use Microsoft SQL Server 2012 or SQL Server 2014 PowerPivot Gallery with a source that uses Windows authentication. When you refresh the document in the PowerPivot Gallery, you receive the following error message in the history:
Call to Excel Services returned an error
In the associated Unified Logging Service (ULS) logs, you receive the following entries:
<Date> <Time> w3wp.exe (<ServerName>:0x4F54) 0x8420 PowerPivot Service Data Refresh 41 High The following exception occured during datarefresh on <http://contoso.com/global/PowerPivot%20Gallery/Sample.xlsx><Date> <Time> w3wp.exe (<ServerName>:0x4F54) 0x8420 PowerPivot Service Data Refresh 99 High EXCEPTION: System.InvalidOperationException: Call to Excel Services returned an error. ---> Microsoft.AnalysisServices.SPClient.Interfaces.ExcelServicesException: ECS failed with non-zero return status. First error is name='ExternalDataRefreshFailed'; message='An error occurred while working on the Data Model in the workbook. Please try again. We were unable to refresh one or more data connections in this workbook. The following connections failed to refresh: AnalysisServices ESESSMW2416 TabularRoleTest '; severity='Error' at Microsoft.AnalysisServices.SPClient.ExcelApi.ValidateStatus(Status[] status) at Microsoft.AnalysisServices.SPClient.ExcelApi.Call[T](String fileUrl, ExcelServiceCall`1 serviceCall) --- End of inner exception stack trace --- at Microsoft.AnalysisServices.SPClient.ExcelApi.Call[T](String fileUrl, ExcelServiceCall`1 serviceCall) at Microsoft.AnalysisServices.SPClient.ExcelApi.Call(String fileUrl, ExcelServiceCall serviceCall, String methodName, Object[] parameters) at Microsoft.AnalysisServices.SPAddin.DataRefresh.DataRefreshService.ProcessingJob(Object parameters) <Date> <Time> w3wp.exe (<ServerName>:0x0660) 0x87E4 Excel Services Application Excel Calculation Services aiau8 Medium ASPPERRORINFO dump:[ Errorcode:aspperrConnectionFailed EXCEPTION MESSAGE: Out of line object 'DataSource', referring to ID(s) 'ce6e0e6a-bad8-4746-ad65-c954726d0b69', has been specified but has not been used. OLE DB or ODBC error: The following system error occurred: The system cannot find the file specified. . Note. Analysis Server has persisted any security information specified as part of the Connection string portion of the Datsource object definition. ] 88edd3e8-1bee-41e0-9b81-2dc8287d4a44<Date> <Time> w3wp.exe (<ServerName>:0x0660) 0x87E4 Excel Services Application Excel Calculation Services alteq Medium PivotException::GetExceptionFromHr: hr -2146827284. 88edd3e8-1bee-41e0-9b81-2dc8287d4a44<Date> <Time> w3wp.exe (<ServerName>:0x0660) 0x87E4 Excel Services Application Excel Calculation Services aei88 Medium UserWorkbook.HandleExternalDataRefreshFailure: Failed to execute query, sessionId=1.V22.16wxz+NxNW8nyO4cO9F1BM14.5.en-US5.en-US36.4ec7f2c7-16a8-4897-8512-9a7b55f767b11.A1.N, exception=Microsoft.Office.Excel.Server.CalculationServer.Interop.PivotException: Exception of type 'Microsoft.Office.Excel.Server.CalculationServer.Interop.PivotException' was thrown., externalsource=AnalysisServices <ServerName> TabularRoleTest, extendedConnectionInfo=Microsoft.Office.Excel.Server.CalculationServer.ExtendedConnectionInfo 88edd3e8-1bee-41e0-9b81-2dc8287d4a44<Date> <Time> w3wp.exe (<ServerName>:0x0660) 0x87E4 Excel Services Application Excel Calculation Services agp5r Medium UserWorkbook.MarkPowerpivotTablesRefreshed: Failed to refresh, tables=Query 88edd3e8-1bee-41e0-9b81-2dc8287d4a44
Resolution
Cumulative Update information
The issue was first fixed in the following cumulative update of SQL Server.
Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. We recommend that you download and install the latest cumulative updates for SQL Server:
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
