Deployment Checklist: Reporting Services, Power View, and Power Pivot for SharePoint
Use the following checklist to install these BI features in the same SharePoint farm: Power Pivot for SharePoint, Report Builder, and Power View. Although this checklist recommends a specific installation order, in practice you can install these features in almost any order. This checklist assumes installation of the following products or features:
SharePoint Server 2010 with Service Pack 1 (SP1)
SQL Server 2016 Database Engine
SQL Server 2016 Reporting Services and Reporting Services Add-in
SQL Server 2016 Power Pivot for SharePoint
After you install these features, you will be able to do the following.
Access the Power Pivot workbooks that you created in Power Pivot for Excel from SharePoint sites.
Build interactive Power View reports based on Power Pivot workbooks in SharePoint.
Create Report Builder reports when you launch Report Builder in SharePoint.
Power Pivot for SharePoint requires that you install SharePoint 2010 Service Pack 1 (SP1) on the SharePoint farm. If you are installing the software for evaluation purposes, consider starting with a clean server so that you can avoid the overhead of a farm upgrade step. Upgrading a farm is impactful to SharePoint operations and typically requires careful planning. If your goal is to install Power Pivot for SharePoint as quickly as possible, follow this approach: install SharePoint 2010, install SharePoint 2010 SP1, then configure the farm in a later step. Upgrade is avoided because the farm is not yet configured when you install SharePoint 2010 SP1.
In this checklist, the farm configuration step is assumed during Power Pivot for SharePoint configuration, using the Power Pivot Configuration Tool. Alternatively, you can use the SharePoint Product Configuration wizard if you prefer that approach. Both approaches result in an operational farm that supports Power Pivot for SharePoint.
You must be a local administrator to run SQL Server Setup.
SharePoint Server 2010 enterprise edition is required for Power Pivot for SharePoint. You can also use the evaluation enterprise edition.
SharePoint Server 2010 SP1 must be installed. Without it, you cannot configure the farm to use SQL Server 2016 features.
The computer must be joined to a domain.
You must have one or more domain user accounts to provision the services. You will need domain user accounts for the following services: SharePoint web services and administrative services, Reporting Services, Analysis Services, Excel Services, Secure Store Services, and Power Pivot System Service. Domain accounts are required by the managed accounts feature in SharePoint. The Database Engine can be provisioned using a virtual account, but all other services should run as a domain user.
The Power Pivot instance name must be available. You cannot have an existing Power Pivot named instance on the computer on which you are installing Power Pivot for SharePoint.
If you are installing Power Pivot for SharePoint on an existing farm, you must have one or more SharePoint web applications that are configured for classic mode authentication. Power Pivot data access will only work if the web application supports classic mode authentication. For more information about classic mode requirements, see Power Pivot Authentication and Authorization. For more information on system and version requirements, see Guidance for Using SQL Server BI Features in a SharePoint 2010 Farm.
The following steps assume that an administrator is installing and configuring the server. The Setup user in SharePoint is also a farm administrator and often the primary site administrator for the default site collection. If you are dividing the following steps among several people, additional permissions might be required in order for the following steps to work.
Run the SharePoint 2010 Products Preparation Tool
You must have the SharePoint 2010 installation media. The preparation tool is PrerequisiteInstaller.exe on the installation media.
Install SharePoint Server 2010 enterprise or enterprise evaluation edition.
When installing SharePoint, you can choose to configure the farm later by not running the SharePoint 2010 Product Configuration Wizard after Setup is finished. Waiting to configure the farm will allow you to use a SQL Server 2016 Database Engine instance, which is installed in a later step, as the farm’s database server. To configure the farm, you will use the Power Pivot Configuration Tool. It includes actions for provisioning the farm if the farm is not yet configured.
Install SharePoint Server 2010 SP1.
Download SP1 from http://support.microsoft.com/kb/2460045.
Run SQL Server 2016 Setup to install the Database Engine and Power Pivot for SharePoint.
Step 1 explains how to install Power Pivot for SharePoint. In this step, be sure to click the checkbox on the Setup Role page that adds the Database Engine to the role. Doing so adds the Database Engine to your installation so that you can use it as the farm’s database server when you configure the farm in the next step. However, if the farm is already configured, you can skip this step.
Step 2 asks you to configure the server. For this step, choose the Power Pivot Configuration tool. Although several approaches are available, using the configuration tool is the most efficient approach for a standalone installation.
If SharePoint 2010 is installed but not configured, the tool pre-selects actions that will create the farm, a default web application, and a root site collection. Be sure to leave these options selected so that the farm will be created. If you already configured the farm, the tool will omit these actions, and offer just the actions that are necessary for configuring Power Pivot for SharePoint.
Step 3 instructs you to install the SQL Server 2008 R2 version of the Analysis Services OLE DB Provider. This step is important for supporting versions of a workbook that were created in the 2008 R2 version of Power Pivot for Excel.
Verify the farm is operational.
First, start Central Administration and confirm that it is available. Next, open the team site by entering http://localhost. You should see a SharePoint team site.
Verify that Power Pivot for SharePoint is operational.
This task confirms Power Pivot data access using a sample workbook that you upload.
Run SQL Server 2016 Setup to install and configure Reporting Services and the Reporting Services Add-in.
Optionally, while installing Reporting Services, you can add an additional Analysis Services instance to the Setup feature tree if you want a second resource for hosting tabular data. The additional Analysis Services instance would be used to host tabular model databases that you create in SQL Server Data Tools (SSDT). Tabular databases are a valid data source for Power View reports.
Verify that Reporting Services is operational.
(Site Administrators) Configure SharePoint permissions.
Contribute permissions are required to add, edit, or delete items in SharePoint libraries. View permission level is sufficient for read-only access to reports and Power Pivot workbooks that present embedded data.
Power Pivot workbooks that are accessed as external data sources (where the workbook URL is a connection string in another workbook or report) require Read permissions, which is higher than View permissions.
BI semantic model connections also required Read permissions. You might need to create new permission levels or SharePoint groups to get the correct permissions in place.
(Site Administrators) Extend document libraries
Extend document libraries to use BI content types: BI semantic model connections, Reporting Services Shared Data Sources, Report Builder reports:
For more information, see Add a BI Semantic Model Connection Content Type to a Library (Power Pivot for SharePoint) and Add Report Server Content Types to a Library (Reporting Services in SharePoint Integrated Mode).
(Site Administrators) Create data connection files that are used to launch Power View.
You must create a BI semantic model connection (.bism) or a Reporting Services shared data source (.rsds) as a data source for Power View. After you create a data connection file, you can launch Power View using the data connection as its data source.
Note: Power View is available because you installed the SQL Server 2016 version of Reporting Services and configured the server as a shared service. If you installed Reporting Services and configured it for the SQL Server 2008 level of integration, Power View is not available.