How to create a power pivot library in SharePoint 2013 (how to create a PowerPivot Gallery) for such a feature to waste me a morning's time. The requirement is to create a power point library in a SharePoint2013 environment. 1, open Web site-Site Settings-site collection Management-site collection features.
Activating the Power Pivot site collection feature
If not found, the English version is
Note here that if you do not have this, you need to reconfigure power pivot. My time is wasted here. 1. Click "Start" > "All Programs" > "Microsoft SQL Server" > "PowerPivot for SharePoint Configuration".
2. Select the Configure or repair Power Pivot for SharePoint option, and then click OK.
3. In the left pane of the Power Pivot Configuration tool, select the Create PowerPivot service application.
4. On the Parameters tab, clear the Include this action in the Task List check box. This prevents the tool from creating a service application for Power Pivot. Later, we will manually create the Power Pivot Service application.
This also prevents further configuration steps from being completed, but we will also return to the following steps later.
5. Click "Run".
6. Click Yes to confirm.
7. When the operation is complete, click OK, and then click Exit.
Create a Power Pivot service application
1. In central Administration, under Application Management, click Manage Service Applications.
2. From the Ribbon, click New, and then click SQL Server Power Pivot Service Application.
3. Type the name of the service application in the Name text box.
4.
Type the name of the new application pool in the application pool name text box. example, this must be the creation of a new application pool
5. From the Configuration drop-down list, select the account that you registered as the administrative account for the Power Pivot application pool.
6. Click OK.
Configure the unattended data refresh account
1. In central Administration, under Application Management, click Manage Service Applications.
2. Click the Power Pivot Service application.
3. Under Actions, click Configure Service Application settings.
4. Under Data refresh (approximately one-third down), type the target application ID (Powerpivotunattendedaccount) of the target application that was created in the PowerPivot unattended data refresh account box.
5. Click OK.
run the Power pivot for SharePoint Configuration tool to activate the Power pivot feature, and if activation fails, go to central administration to activate it.
1. Click "Start" > "All Programs" > "Microsoft SQL Server" > "Power Pivot for SharePoint Configuration".
2. Select the Configure or repair Power Pivot for SharePoint option, and then click OK.
3. In the left pane of the Power Pivot Configuration tool, select Activate Power pivot features in the site collection.
4. On the Parameters tab, from the Site URL drop-down list, select the site collection where you want to activate Power Pivot.
5. If you changed the default site collection settings, click Validate.
6. Click Run, and then click Yes to confirm.
7. When the operation is complete, click OK, and then click Exit.
Now that power pivot is set up, power pivot is ready to use.
If there is an error after the increase, reconfigure the 1,sharepoint of the database 2013 2
Turn on the following tool to reconfigure.
How to create a Power pivot library (how to create a PowerPivot Gallery) and error resolution in SharePoint 2013
