FIX: "Call to Excel Services returned an error" error when you refresh the document in the PowerPivot Gallery

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.

Recommendation: Install the latest cumulative update for 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.
Properties

Article ID: 3034492 - Last Review: 06/22/2015 15:49:00 - Revision: 4.0

Microsoft SQL Server 2012 Service Pack 2, Microsoft SQL Server 2012 Business Intelligence, Microsoft SQL Server 2012 Analysis Services, Microsoft SQL Server 2014 Service Pack 1, Microsoft SQL Server 2014 Business Intelligence

  • kbqfe kbfix kbsurveynew kbexpertiseadvanced KB3034492
Feedback