I have had several customers experience the PowerPivot "scheduled data refresh" running over and over when setting the Schedule Details to Monthly and choosing a Day. Refresh Settings: As you can see below, the refresh runs over and over; it's stuck in a loop. In this case every 5 seconds. If the Data Model was larger…
Tag: Failed to Refresh
PowerPivot 2013 for SharePoint – "External Data Refresh Failed" using Interactive Data Refresh via "Use the authenticated user's account"
When refreshing in the browser you may come across this error: "External Data Refresh FailedAn 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:<Connection>" This happens when you choose Data > "Refresh…
PowerPivot for SharePoint – Browser Refresh Fails (Data Refresh not supported in Office Web Apps)
We have been seeing Excel Services/PowerPivot data refresh issues using SharePoint 2013 and Office Web Apps (OWA). Some customers have been running into issues when attempting to refresh data in a PowerPivot workbook on SharePoint 2013 using OWA server, and are seeing errors similar to the following: "PivotTable Operation Failed An error occurred while working…