The resource object with key ‘DataRefresh_Warning_DataSources’ was not found

UPDATE: 1/31/17 – We have expanded the list of patches this is affecting! We have also confirmed it is only affecting SharePoint 2013 (To be more specific, SharePoint 2010 and 2016 appear to be unaffected at this point)! If you have not already installed the following patches on your PowerPivot for SharePoint Analysis Services instance and/or…

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…

0

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


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

Excel Services and PowerPivot error: "Retrieving the COM class factory for component with CLSID {BDEADF26-C265-11D0-BCED-00A0C90AB50F} failed due to the following error: 800703fa"

When you open a workbook in the browser using Excel Services and get an error, or when a scheduled data refresh fails in PowerPivot for SharePoint, you may see the following error in the ULS logs: Retrieving the COM class factory for component with CLSID {BDEADF26-C265-11D0-BCED-00A0C90AB50F} failed due to the following error: 800703fa If you…

0