Saturday, February 20, 2016

Prepare a SharePoint 2013 site for PowerPivot workbooks

Following are the steps I use to configure a SharePoint 2013 site to work with PowerPivot workbooks

Activate following site collection features

image

image

As a result Business Data webparts will appear in webparts collection

image

Create a Data Connection Library and add BISM content types

image

Configure Excel Services service application settings

image

image

image

image

image

That’s all we have to do. Now you can upload your workbooks.

No comments: