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…


Configuring the MSOLAP data provider version

When you create a data connection to an Analysis Services data source in Microsoft Excel, the Microsoft Analysis Services OLE DB Provider for Microsoft SQL Server (MSOLAP) is used for the data connection. Each version of Analysis Services has its own MSOLAP provider version. Here is a list of versions: MSOLAP.4 – SQL Server 2008 MSOLAP.5…


"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 – Error when running PowerPivot Configuration Tool: "The user is not a farm administrator."

You may receive the following error when running the PowerPivot Configuration Tool on a SharePoint application server running PowerPivot for SharePoint:     The user is not a farm administrator. Please address the validation failures and try again.   The user is required to be both a farm administrator and a site collection administrator in…


Excel Services – Consuming a SharePoint List using the ListData.svc

Here are the steps I performed to Consume a SharePoint List in Excel Services (SharePoint On Premise): I created a list at this location: http://sp/_layouts/15/start.aspx#/Lists/TomTestList/AllItems.aspx   I then called the listdata.svc from via Excel > Data tab > From Other Sources  > From Odata Feed > http://sp/_vti_bin/listdata.svc I selected my List. I then created a simple…


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


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…


PowerPivot for SharePoint – "SetAuthContext need to be run as sysadmin" error

If you receive an error when interacting with a PowerPivot workbook in SharePoint, you may see the following error from the PowerPivot Service in the SharePoint ULS log:   EXCEPTION: System.ServiceModel.FaultException`1[System.ServiceModel.ExceptionDetail]: SetAuthContext need to be run as sysadmin.   This error refers to the Administrator permission on the PowerPivot Analysis Service instance. To fix the…


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…