Chapter 35. Installing the BI Components for SharePoint
In this chapter, we will cover the installation and configuration of
the components that make up SharePoint’s business intelligence suite. We
will be walking through the installation of each piece and discussing the
variables that should be configured to support the best implementation of
The areas that we will cover are:
SQL Server 2012 for PowerPivot
PowerPivot Office client
SQL Server Reporting Services Integrated Mode
At the end of this chapter, you will be able to properly install and
configure the SharePoint BI suite.
SQL 2012 for PowerPivot on the App Tier
There are two distinct paths for installation of PowerPivot on the
App Tier that this section will cover:
Upgrading from PowerPivot 2008 R2 (version 1) to 2012 (version
Clean install of PowerPivot 2012 (version 2)
Upgrading from PowerPivot 2008 R2 to 2012
One question that is frequently raised around the installation of
PowerPivot under SQL 2012 is “What do I do if I have PowerPivot under
SQL 2008 R2?” There is an important distinction that needs to be made
here regarding versions. PowerPivot is a single-tier upgrade path only.
This means that you cannot go from version 1 (SharePoint 2010 and 2008
R2) to version 3 (SharePoint 2013 and SQL 2012 SP1) without upgrading to
version 2 (SharePoint 2010 and SQL 2012) first.
To upgrade from PowerPivot version 1 to PowerPivot version 2, the
following must be true:
The version of SQL Server must be ...
With Safari, you learn the way you learn best. Get unlimited access to videos, live online training,
learning paths, books, interactive tutorials, and more.