PowerPivotGeek?

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

Health rule error reports: “PowerPivot: The deployed farm solution is not up-to-date.”

I recently ran into this in scanning through some forum problem reports. Typically this health rule violation is reported on a large farm installation. The health rule reports the app servers that do not have PowerPivot installed on them as being out of date. Can you read “bug?” Yes, this is one. You can either [...]

Installation error: “System.IO.FileLoadException: Loading this assembly would produce a different grant set from other instances.”

Occasionally I’ve ran into this problem as part of a SharePoint installation. Typically this is with Excel Services – but since Excel Services is so central to the PowerPivot architecture, we run into this too. The ULS shows something like:

Medium             ExcelServiceBase.BeginProcessOperation: Caught an exception: System.TypeInitializationException: The type initializer for ‘Microsoft.Office.Excel.Server.CalculationServer.ExcelServerApp’ threw an exception. —> System.IO.FileLoadException: [...]

A Peek Inside: Getting the most from data refresh

Recently there was a forum post concerning how PowerPivot parallelizes data refresh . . and I thought this might be an interesting topic for a “Peek Inside” blog posting. The first question is: Why are we doing this? What is the purpose of parallelizing data refresh? Why is this so important? Well . . there [...]

“Unsupported features” warning message from Excel Services

(Thanks to Ankur Goyal, one of the PowerPivot mid-tier testers, for this detailed write-up)

You might have noticed that Excel Services sometimes complains about how the PowerPivot workbook is organized. It reports an warning error like this one::

In this posting, I’ll talk about why these rectangles exist (i.e. what they do) and how you can have [...]

SharePoint Timer Service error

In another one of those “oh heck, I just spent a couple hours of my life chasing my tail” and in an effort to ‘prepare everyone for RTM’, you might notice the following error pop up from time to time.

And in the NT Event Log you might seen entries like:

An unhandled exception occurred and [...]

Bug: Management Dashboard .odc file is broken

OK, here is our first ‘bug’. As part of the PowerPivot Management Dashboard, we ship a .odc file that is used to point to the PowerPivot dashboard data workbook (the data you see in the dashboard reports). You can click on the .odc file and Excel desktop will popup pointing to the dashboard data. Unfortunately [...]