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