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…


The resource object with key ‘DataRefresh_Warning_DataSources’ was not found

UPDATE: 8/16/17 – This issue should be fully resolved with the below patches!! 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 SP1…


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,…


Is my PowerPivot for SharePoint install causing my problems?

Over the years, we have had customers engage us for PowerPivot configuration cases, but the issue lies in the PowerPivot install.  But before I dive into errors, etc.  I will first explain the PowerPivot Install (for SharePoint 2010 and SharePoint 2013). There are two areas that need to be configured. 1. Analysis Services (AS) needs…


Run the "PowerPivot Configuration Tool" after Upgrading the Analysis Services POWERPIVOT Instance.

After applying an update to the Analysis Services Server running PowerPivot, you also need to upgrade the sppowerpivot.msi on the SharePoint Server running PowerPivot and re-run the PowerPivot Configuration Tool.  These two (SQL and SharePoint) need to have matching builds.  For example, if you apply the Cumulative update package 7 for SQL Server 2012 Service Pack 1 to…


Data Refresh using DSN in Excel Services and PowerPivot for SharePoint 2013

Over the last few months, we have seen a few more instances of people using data sources that require a DSN connection to retrieve data for PowerPivot and Excel workbooks. Normally, if you are just using these data connections inside the client, you just refer to the DSN as a data source and all is…


With PowerPivot 2012 for SharePoint 2013, thumbnails may not always generate properly in the PowerPivot gallery for non-PowerPivot workbooks (red X)

Issue Consider this scenario: You have a SharePoint 2013 environment with the PowerPivot 2012 add-in for SharePoint installed. You have non-PowerPivot workbooks in your PowerPivot gallery, and you have successfully set up scheduled data refreshes for those non-PowerPivot workbooks. When you upload the non-PowerPivot workbooks to the PowerPivot gallery, thumbnails for those workbooks are generated successfully….


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…


BISM icons not present in SharePoint 2013 Library

We have worked several cases where BISM icons are no longer present in a SharePoint Library.  In the below screenshot you can see the icon is a blank square. We have found that the mapping is no longer present in the DOCICON located in one of the two directories (dependant on the version you are…