PowerPivotGeek?

Who is this mystery man?
Click on the icon to find out. Who is powerpivotgeek?

Archives

PowerPivot and Windows 7

Recently I had a conversation with one of our excellent beta testers and I want to make sure that everyone was clear about running PowerPivot on Windows 7.

Windows 7 is only supported for PowerPivot for Excel; Windows 7 is not a supported OS for PowerPivot for SharePoint

Installing the right version of SharePoint

So you think that you have done everything right, but still SQL setup (in PowerPivot SharePoint integration mode) still reports “You don’t have a ‘Complete’ SharePoint installation.” How can this happen?

You might not have followed the installation guide. It tells you to first select “Farm” and then “Complete” on your first two screens after you [...]

Cannot add the specified assembly to the global assembly cache

This is part of my continuing series on debugging SharePoint and PowerPivot. In this case, I do not expect any PowerPivot users to ever encounter this error in the context of PowerPivot. However, the general SharePoint developer who is in the early stages of building and testing his custom solutions might hit this and since [...]

The data connection uses Windows Authentication and user credentials could not be delegated

This is one of the two main errors that users could see from Excel Services when using PowerPivot. This is encountered when refreshing PowerPivot data connections or performing an action which requires re-querying the PowerPivot database, such as clicking on a slicer or expanding a node in a pivot table. To debug, some level of [...]

Dashboard Bubble Chart Shows a Red X (fails to load)

If there is any error trying to load the bubble chart data for the dashboard, instead of getting a page load failure, the bubble chart simply displays a red X. Whenever you get a red X in the bubble chart there will be an associated log entry in the ULS log on the machine running [...]

A connection corresponding to the embedded PowerPivot data was not found in the Excel workbook

This error is another in a series of common errors that users can hit during seemingly normal scenarios that might be a little bit difficult to interpret at first. We actually did work to try and make the error descriptive, but to the new user, it may still be cryptic. This error occurs when you [...]

Weird timer jobs

Sometimes when you look at the timer jobs associated with the PowerPivot service application you see these weird entries:

So where do they come from and what do they do?

Ans: It just so happens that one of the little known aspects of PowerPivot is that we have written a series of health rules that scan [...]

What database support is needed

I get this question a lot and I thought that it was a good one to address here in the blog.

If you look at the PowerPivot for SharePoint architecture, you know that we use several SQL Server 2008 R2 components within the architecture, but how about SharePoint itself . . . What RDBMS does PowerPivot [...]

How to start debugging a PowerPivot for SharePoint installation issue

A number of people have had issues with PowerPivot installation failures in CTP3. Hopefully, we have resolved all of these for RTM, but I can tell you that setup is still a bit tricky. To give you something of an understanding, the “New Farm” installation option is responsible for getting your machine up and running [...]

Could not load type ‘Microsoft.AnalysisServices.SharePoint.Integration.ReportGalleryView’.

A number of people have hit this issue and so it deserves a quick walkthrough of why it (unfortunately) can happen and how you fix it.

The error occurs when you try to select a Document Library of type PowerPivot Gallery (sometimes referred to as Report Gallery). After installing Power Pivot for SharePoint, all new [...]