Why won’t my PowerPivot for Excel 2010 workbook upgrade to Excel 2013?

Recently we’ve seen an issue where some Excel 2010 workbooks containing PowerPivot models encounter errors when attempting to upgrade to Excel 2013. When opening a PowerPivot model that was created in Excel 2010 in Excel 2013 you will be prompted to upgrade with the following message: This workbook has a PowerPivot data model created using…

2

PowerPivot Table Import Wizard cannot find provider

The data source provider list in PowerPivot can often be a source of confusion for users since they equate the fact that a provider appears in the list as the provider being installed and available. Unfortunately, the list of providers is actually a static list of supported data sources for PowerPivot, so the user is…

10

Getting a Power View report within Excel 2013 to work with SharePoint

I was setting up my SharePoint 2013 server to be able to use an Excel 2013 workbook that had a Power View Report in it.  However, when I tried opening the workbook, I got the following error: In the ULS logs of my SharePoint server that had RS installed on it, I saw the following:…

7

FileNotFoundException with Microsoft.AnalysisServices.Xmla

I ran across two cases that were hitting the following Exception within SharePoint trying to run the PowerPivot Management Portal.  This was located in the SharePoint ULS Log: EXCEPTION: System.IO.FileNotFoundException: Could not load file or assembly ‘Microsoft.AnalysisServices.Xmla, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91’ or one of its dependencies. The system cannot find the file specified.  File name: ‘Microsoft.AnalysisServices.Xmla,…

1

PowerPivot : When versions get mixed up…

I worked a case today where they were trying to get SQL 2012 Reporting Services installed in a SharePoint environment that also had SQL 2008 R2 PowerPivot installed.  This, by itself, is fine and wasn’t really causing the problem.  When they tried to open the Excel Workbook from SharePoint that had the PowerPivot data in…

5

My Kerberos Checklist…

I’ve had numerous questions regarding Kerberos, both internally within Microsoft and with Customers.  It continues to be a complicated topic and the documentation that is out there can be less than straight forward.  Based on some previous items I’ve worked on, I wanted to share my experience in regards Let me start by looking at…

11