PowerPivot for SharePoint 2016 Scheduled Data Refresh Error: “The operation has timed out”

UPDATE: 4/25/17: PowerShell to increase timeout included in workaround section. Scenario: You create a PowerPivot workbook with one or more data sources and upload it to SharePoint 2016. You then schedule the workbook to refresh and the refresh fails with the following error: “The operation has timed out”. Cause: This issue is caused by a…


PowerPivot – Scheduled data refresh get stuck in a loop (runs over and over).

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…


PowerPivot Scheduled Data Refresh: "The workbook must be checked out before it can be replaced. You can save this file with another name."

Scenario: You get the following error while running a scheduled data refresh on a PowerPivot workbook:   Problem: The "Require Check Out" option inside of the Document Library Settings > Versioning Settings of any given document library is likely set to "Yes":   Resolution: PowerPivot does not attempt to check out documents when it makes…


PowerPivot for SharePoint – "An error occurred when loading the Sandbox cube"

You may receive an error similar to the following when running a scheduled data refresh of a PowerPivot workbook in SharePoint: The table with ID of '<TableID>', Name of '<TableName>' referenced by the 'Sandbox' cube, does not exist. An error occurred when loading the Sandbox cube, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.POWERPIVOT\OLAP\Backup\Sandboxes\PowerPivotServiceApplication\<GUID>.db\Sandbox.9825.cub.xml'. You might…


FIXED – PowerPivot Scheduled Data Refresh – Call to Excel Services returned an error.

This issue is fixed in SharePoint 2013 SP1 (Released Feb 25th 2014): Update center for Office, Office servers, and related productshttp://technet.microsoft.com/en-US/office/ee748587.aspx    Issue: "Call to Excel Services returned an error" when performing a Scheduled Data Refresh. In the ULS logs,  you will see: w3wp.exe (0x0A28)            0x0DB8  PowerPivot Service             Data Refresh        99           High                EXCEPTION: System.InvalidOperationException: Call to Excel…


What is PowerPivot for SharePoint? Part 2.

Now that we have a PowerPivot workbook in the Excel Rich Client, we are ready to publish that workbook to SharePoint. In “What is Power Pivot for SharePoint? Part 1” I discussed the Data Model and how it is a database inside of Excel.  When you publish/upload a regular Excel workbook to SharePoint, that file gets chunked up…


PowerPivot for SharePoint – Schedule Data Refresh Error: "A schedule cannot be enabled for a workbook with no external data sources."

If you come across this error when trying to perform a scheduled data refresh: “A schedule cannot be enabled for a workbook with no external data sources.” This is because the Data Model cannot be created on the PowerPivot Server. Your probably have two questions. 1. What is a “Data Model”. The Data Model is…


PowerPivot for SharePoint 2010 & SQL 2012 – Refresh in browser fails due to multiple "Process" Data Models in Analysis Services.

    When opening a workbook after a Schedule Data Refresh, the workbook does not open in Excel Services:     This is because after a Scheduled Data Refresh, the “Refresh data when opening the file” is checked.  This is by design, because after a Scheduled Data Refresh, the workbook’s Data Model is updated with…


PowerPivot for SharePoint – Scheduled Refresh to Oracle, IBMDB2, Teradata, SQL (en-US)

PowerPivot for SharePoint – Scheduled Refresh to Oracle, IBMDB2, SQL (en-US) Here is how to create a Scheduled Refresh to an Database that does not accept domain credentials in PowerPivot: Create 2 SSS IDs:   1. PowerPivotDataRefresh   a. Create a SSS application using Group leaving application Page URL to none. b. Utilize the Windows Username/Password template….