Archive for the 'Uncategorized' Category


With all that is going on these days, I have not been doing a good job of keeping this aggregator site up to date. With that, I will say – I will no longer be updating this site because of the frentic pace that Dave and I are updating our own respective sites. Saying ths, for more information, please go to:

Dave Wickert:
Denny Lee:



PowerPivot for SharePoint: Single Server Installation

August 30, 2010 by dennyglee

300px-Opening_crawlA long time ago, but not in a galaxy too far away…actually, just in Redmond, WA,… there was A NEW HOPE for easier PowerPivot for SharePoint installations! Smile

So hats off to the Analysis Services product team for building an easier PowerPivot for SharePoint installation by providing us with the “New Server” installation choice.    Yet, even with the easier installation steps, it is important to make sure you do the steps in the right order and have the correct prerequisites installed to make it a smooth installation experience.

Click through to continue reading: PowerPivot for SharePoint: Single Server Installation

SharePoint 2010 revised ULSViewer

By powerpivotgeek (, on August 21st, 2010
From time to time I get questions from folks asking me “What is the best debugging tool for PowerPivot?” – The Answer is that there is clear cut favorite and it is EXTREMELY useful, but I didn’t know that it was released to the public. Well . . . after some investigation, it looks like it is available – not only that, it has been for a while. But better late than never . . take a look at it!

Please click through to continue reading SharePoint 2010 revised ULSViewer

Cannot add the specified assembly to the global assembly cache

By Lee Graber (, on February 12th, 2010

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 so many people on our team have been confused by it, I thought I would throw out some help for other developers. This error is hit when trying to deploy a SharePoint solution package to the farm. It could be an ApplicationServer solution or a WebFrontEnd solution, the important part is that it has an assembly marked to be deployed to the GAC:

Read more…

More great PowerPivot resources!

As you already may know, we have a couple of forums for PowerPivot at:

Dave Wickert with his site has also created two new sections:

  • Reported Problems section which compiles the different issues concerning PowerPivot for SharePoint installations and
  • Troubleshooting section which complies different Troubleshooting issues concerning PowerPivot for SharePoint installations.

Please do not forget that the all four PowerPivot for SharePoint installation guides can be found here as well.

Rob Collie has also put together:

where you can see some of the key MVPs respond to some great questions concerning PowerPivot …disclosure: myself and Dave are also answering questions there 🙂

The coup de grace of course is is Dave and my downloadable Academy Live presentation which

This will definitely help jump start your PowerPivot for SharePoint geekiness.


[Originally posted at]

Welcome to PowerPivot Twins!

We are the PowerPivot Twins!  And who are the PowerPivot Twins you ask?  We are Denny Lee from the SQL Customer Advisory Team and Dave Wickert from the Analysis Services Team.  This site is dedicated to all things PowerPivot, eh?!

Over the next few days, we’ll be aggregating posts from – Dave Wickert’s excellent blog and PowerPivot materials from the SQL Customer Advisory Team site that Denny Lee is part of.  We’ll of course add new material here as well!

Oh, and we’ll aggregate and/or link to great PowerPivot blogs  as well such as Rob Collie’s 

PowerPivot Twins Powers… Activate!!

Hello world!

Welcome to This is your first post. Edit or delete it and start blogging!

Denny Lee’s Tweets (1/2 of PowerPivot Twins!)


Copyright © 2010 Denny G Lee - All Rights Reserved