All About PowerPivot for SharePoint 2016

The purpose of this post is to aggregate helpful links for SharePoint 2016 PowerPivot, to make it easier for anyone to understand the service use/deployment and configurations. Please add your comments with other helpful links and I will update the post as needed.

Overview:

Microsoft SQL Server PowerPivot for SharePoint extends SharePoint 2016 and Office Online Services to add server-side processing, collaboration, and document management support for the PowerPivot workbooks that you publish to SharePoint.
PowerPivot workbooks are Excel workbook (.xslx) files that contain large, related datasets that you build in a separate PowerPivot window in Excel, and use with PivotTables and PivotCharts in a worksheet.

Prerequisites:

• SharePoint Server enterprise edition is required for Power Pivot for SharePoint. You can also use the evaluation enterprise edition.
• The Power Pivot instance name must be available. The instance name must be POWERPIVOT.
• Office Online Server (Need steps on how to deploy and configure, press here and here).

Deployment:

1- Install SQL Server Analysis Services in PowerPivot Mode):
        https://msdn.microsoft.com/en-us/library/jj219067.aspx (White Paper)
2- Install PowerPivot for SharePoint add-in:
        https://msdn.microsoft.com/en-us/library/mt595853.aspx

Configuration:

  Configure PowerPivot solutions and services:
        https://msdn.microsoft.com/en-us/library/mt595855.aspx

Usage:

Nice article by Tom S. on What is PowerPivot for SharePoint (part 1 and part 2).