Dieser Artikel steht nur in englisch zur Verfügung.
Part 1: Installing SQL Reporting Services
Part 2: Configuring Reporting Services
Part 3: Installing PowerPivot for SharePoint
Part 4: Configuring PowerPivot for SharePoint
Part 5: Configuring PerformancePoint Services
After the installation is successfully completed go to SharePoint Central Administration > Systems Settings > Farm Management > Manage farm solutions and make sure that the two PowerPivot Solutions are deployed to the Web Applications.
In Central Administration navigate to Systems Settings > Servers > Manage services on server and make sure that the following services are started: Claims to Windows Token Service, Excel Calculation Services, Secure Store Service, SQL Server Analysis Services, SQL Server PowerPivot System Service.
In Central Administration > Application Management > Manage Service Applications > Excel Services Application reconfigure your existing settings:
In Trusted File Locations add your Portal and your Central Administration URL, also check the Children Trusted checkbox, Change the Maximum Workbook Size to 2000 and the Maximun Chart or Image Size to 100.
If no PowerPivot Service Application exists, create a new one in Central Administration > Application Management > Manage Service Applications > Create a new SQL Server PowerPivot Service Application and add the proxy for this PowerPivot service application to the default proxy group.
In Central Administration > General Application Settings > PowerPivot you may adjust the settings for your needs.
Go to your Site Collection (on which Web Application you activated Reporting Servies earlier) and activate the following:
Under Site Collection Features
Now you can create a New Site using the PowerPivot Site template.
