I have a spreadsheet with a powerpivot data model in sharepoint 2013 sp1 with sql 2012 sp2 for the power pivot instance. The power pivot data refresh works fine when scheduled, when the spreadsheet has just a blank workbook. I then created a basic pivot table using 5 different fields in the query and saved it. After this is done, the data refresh fails saying call to excel services returned an error. It is an oracle data source and the query takes about 17 minutes to run.
When I look in the Sharepoint logs the error says "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.'; severity='Error' "
Any idea on how to troubleshoot this?