I just posted a new diagnostic guide in the troubleshooting section:
“Diagnostic Guide for Usage and the PowerPivot Management Dashboard” by Ankur Goyal
A trick for the client-side folks doing build-to-build reinstallations (or if you wish to clear all of the PowerPivot code from your client): besides uninstalling “Microsoft PowerPivot for Excel” (via control panel Add/Remove/Uninstall Programs, the exact wording varies depending on the OS you are running), you may also have to delete files in:
C:\Program Files\Microsoft Analysis [...]
Recently there have been some discussions on the forums and in other areas concerning how PowerPivot handles nulls. As this has changed between CTP3 (back in November) and the upcoming RTM of the product, I thought that it would be a good posting. Here is the situation: suppose you have a simple calculated measure:
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 [...]
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 [...]
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 [...]
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 [...]
In scanning through some recent discussions on the PowerPivot forums, I noticed this very nice posting by Marco Russo (http://sqlblog.com/blogs/marco_russo/archive/2010/01/26/memory-considerations-about-powerpivot-for-excel.aspx) . I strongly recommend it.
The only additional point I would like to make is that the RTM version of PowerPivot has an additional check on the in-memory database when saving to disk. The CTP3 (and [...]
The Excel 2010 blog just posted an interesting article on the management aspects of PowerPivot – more of a “Why should I care?” kind of article, see (http://blogs.msdn.com/excel/archive/2010/02/01/management-features-of-powerpivot-for-sharepoint.aspx). It shows how PowerPivot helps IT answer:
Where are my mission critical PowerPivot workbooks? And what data is inside them? –> The usage infrastructure records connection information and [...]