PowerPivot for SharePoint 2016 Gallery Snapshots Fail for SSL Host Header Sites

If you have been following the multiple threads  on issues and changes to the PowerPivot for SharePoint 2016 Gallery Snapshots, you may be aware of an issue where gallery snapshots do not function properly (infinite “hourglass”) for SSL sites when there are multiple sites bound to the same port. While not limited to port 443 we will use a generic port 443…


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


"PowerPivot Management Dashboard ProcessingTimer Job" throws error "User cannot be found”.

Updated 9/22/2015 After migrating from a SharePoint 2010 site using Classic Mode Authentication(default) to SharePoint 2013 site in claims mode (default again) using database attach, you will run into a situation where document authors are not converted to the new claims identities by the migration process. This is not limited to Excel documents, but is…


PowerPivot for SharePoint – Server Configuration Check

Every once in awhile, you will get an error where you cannot Slice to the Data Model.  "PivotTable Operation FailedAn error occurred while working on theData Model in the workbook.  Please try again." If this is the case, you will want to make sure PowerPivot is Configured correctly.  To do this, follow the below instructions….


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…


Configuring BI Semantic Model Connections (BISM files) to PowerPivot Workbooks in SharePoint 2013

Many customers come to us with questions surrounding the use of BISM files.  Primarily why should they use them and how to configure them.  In the following I will attempt to answer both questions. Why: When you upload a PowerPivot workbook to SharePoint, SharePoint is intelligent enough to create a Data Model under the Analysis…


PowerPivot workbook with a PowerPivot connection to a SharePoint list cannot be refreshed manually in the browser (Data > Refresh All Connections) using Windows authentication in SharePoint 2013

Issue As we all know 🙂 with SharePoint 2013, manual data refresh in the browser (Data > Refresh All Connections) for PowerPivot workbooks will refresh data all the way back from the original PowerPivot data source, which is specified in the PowerPivot workbook's PowerPivot connection. This functionality is different with SharePoint 2010, where manual data…


Excel Services 2013 issue with IE 11.0.9600.16438 – UPDATE

There appears to be an issue with SharePoint 2013 Excel Services when using IE 11 (11.0.9600.16438).  As noted in the comments below, the issue is resolved by installing the October 2013 Cumulative Update for SharePoint 2013: Description of the SharePoint Server 2013 cumulative update package (SharePoint server-package): October 26, 2013 http://support.microsoft.com/default.aspx?scid=kb;EN-US;2825647 See this blog for detail…


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…


What is PowerPivot for SharePoint? Part 1.

I find myself explaining PowerPivot to customers over and over.  Most understand parts of how it works but not the whole story.  I will touch on two parts; PowerPivot for Excel and PowerPivot for SharePoint. Part 1: PowerPivot for Excel PowerPivot for SharePoint is nothing without the Excel Rich Client and the PowerPivot Add-in.  Pre-Excel…