PowerPivotGeek?

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

New Windows Azure Marketplace announced: DataMarket

So we finally have a product, the codename “Dallas” product is now announced and shipping (or whatever that means as a cloud-based application). I’ll let you read up on the product itself http://www.microsoft.com/windowsazure/marketplace/ – what I want to comment on is what it means to PowerPivot.

First, PowerPivot is right there on-stage with DataMarket. It is [...]

Using a SharePoint list as a data source

Updated 28-Oct-2010: Some folks are reporting that an iisreset is needed to make the updates visible to SharePoint.

So . . . here I am playing around with PowerPivot to get ready for a demo. As this is a group from the SharePoint dev team (actually SharePoint Online), I wanted to include some cool SharePoint functionality [...]

Data feeds: Cannot get schema? But it is there . . .

I always am on the look out for cool applications that use data feeds. Personally I think that it is by far the most interesting new concept in data interchangeability in many years.

So I am very sensitive and want to ensure that users become knowledgeable of its ‘quirks’ as well. Here is a good one. [...]

Importing XML data

So you’ve got a bunch of XML data. How do you get it into PowerPivot? Various ideas:

Import it into Excel using its normal data input capabilities. Once you’ve got the data into a worksheet, you have two options depending on if you are going to modify it later on. If the data is dynamic, [...]

When is the field list not the field list?

So I am playing around with the PowerPivot add-in constructing a new sample application. I’ve got the data and I am inserting pivot tables in my worksheets. All of a sudden I noticed that the field list isn’t the PowerPivot field list – it is the Excel field list. What happened? (I never did figure [...]

PowerPivot and Windows 7

Recently I was making a pass through my old emails and I noticed that several folks have been asking me about PowerPivot and Windows 7. As you know – and I hope that everyone knows – PowerPivot is *NOT* supported on Windows 7. We have very specific prerequisite requirements – and running on a Windows [...]

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: [...]

General problems with Gallery snapshots not being taken – no items listed in the ULS log

For most problems with the Gallery snapshot problem, there are entries in the ULS – but sometimes there are no items or if there are, there is just the “Timeout Exception”. Under these circumstances there is so little to go on that it is hard to figure out how to even get started. Here are [...]

Snapshots not being taken

Recently I ran into an interesting customer situations with Gallery snapshots not being taken – just an hourglass is showing (meaning that the snapshot generation process is on-going, i.e. the GetSnapshot.exe process is running).

The problem is visible in the ULS log with this error:

w3wp.exe (0×1508)                        0×0CF4 SSAS Mid-Tier Service          Report Gallery                 99 High     EXCEPTION: System.Exception: [...]