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…

0

The resource object with key ‘DataRefresh_Warning_DataSources’ was not found

UPDATE: 3/24/17 – First Patch to resolve this issue has been released!!!! (See below) If you have not already installed the following patches on your PowerPivot for SharePoint Analysis Services instance and/or the MSI DO NOT PROCEED WITH THE INSTALLATION! SQL 2012 SP3 CU6 – Resolved (see below) SQL 2012 SP3 CU7 – Resolved (see below) SQL 2014…

1

Changes to PowerPivot Gallery and Snapshots in SharePoint 2016

The PowerPivot Gallery has had some functionality and supportability changes between SharePoint 2013/2010 and SharePoint 2016. This is due to the fact that Excel Services functionality has moved to Office Online Server. While the basic premise of the gallery remains the same and some of the same rules apply, there are some changes that you…

2

Excel Online Cross Forest KCD Data Refresh Not Supported

Scenario: You configure Office Online Server with SharePoint 2013 or SharePoint 2016 and have configured Kerberos Constrained Delegation to a data warehouse to pull business intelligence data for your users. You have two Active Directory domains in separate forests in a 2-way transitive trust configuration (We will call them DomainA in Forest 1 and DomainB in…

0

SQL 2016 PowerPivot Analysis Services Fails on Default Instance

Scenario: You are installing PowerPivot for SharePoint 2016 (or 2013) using SQL 2016 and you notice that you are no-longer restricted to having the instance name “POWERPIVOT” to make it function. As such, you decide to install PowerPivot Analysis Services on the default instance for the sake of simplicity. You continue with your Office Online…

0

Third Party Data Refresh Tools and Negative Interaction with PowerPivot for SharePoint

Recently we have seen multiple instances where custom 3rd party tools/scripts are being used to bypass the standard daily scheduled data refresh limit for PowerPivot workbooks. The main reason we have seen these instances is because these tools have been causing performance issues for SharePoint Web Front End servers that were not accounted for in their…

2

Excel Services crashes continuously

You may experience Excel Services crashing continuously after applying a patch to SharePoint 2013. The issue can be resolved by following these steps:   1. Make sure that the account running Excel Services is part of the groups WSS_WPG and WSS_ADMIN_WPG on the SharePoint servers running Excel Services.   2. Open the SharePoint Management Shell…

0

PowerPivot for Excel – “Memory error”

You may receive the following error when attempting a data refresh using PowerPivot for Excel:     Memory error: Allocation failure : Not enough storage is available to process this command. . If using a 32-bit version of the product, consider upgrading to the 64-bit version or increasing the amount of memory available on the…

4

PowerPivot Workbooks as a Data Source

We have been seeing some issues with customers using PowerPivot workbooks as a source file in new Excel PowerPivot files.  There are a variety of errors that can arise from this process, and this blog is intended to provide you with some troubleshooting steps to resolve the issue. You may or may not be aware,…

6

Find large files across multiple SharePoint content databases

Overview: This blog post contains a tool that will query all content databases on a SQL server looking for files of a given extension and size, it will output a report file that can be loaded into Excel for analysis. PowerPivot can lead to some large workbooks being stored on your SharePoint farms, the tool…

0