Wednesday, March 28, 2012

Installing PowerPivot and Power View

For those that want to have all of the newest SQL BI toys installed in a VM or on your laptop, I have found a couple of really good resources that I use each time I need to install them.

Step by step guide on installing PowerPivot for SharePoint on a single machine
Checklist: Reporting Services, Power View, and PowerPivot for SharePoint

The first link is from, which is a great resource for PowerPivot. The second is an MSDN article that provides the Microsoft perspective on getting it setup. Both of these resources were posted before SQL 2012 was RTM and have been updated since RTM, so they both work very smoothly.

For those that are new to PowerPivot and Power View and wondering why these tools require detailed installation resources is because both of these tools require SharePoint Server 2010 be installed. For those that have not installed SPS2010 yet, it can be challenging, especially to make sure you get the PowerPivot Gallery installed correctly. Thankfully Power View, the newest SQL BI tool on the block, works very well with PowerPivot, so once you have PowerPivot setup Power View is not too hard to add on.

Have fun and enjoy PowerPivot and Power View!