- There are unsupported Excel Services features or a schedule that has a bad password in the workbook.
- A scheduled data refresh is executed on the workbook.
· 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: <ConnectionName>'
The issue was first fixed in the following cumulative update of SQL Server.
Article ID: 2999308 - Last Review: 21 Oct 2014 - Revision: 1