TechNet
Export (0) Print
Expand All

Power Pivot for SharePoint (SSAS)

 

Applies To: SQL Server 2016

An Analysis Services server in Power Pivot mode provides server hosting of Power Pivot data in a SharePoint farm. Power Pivot data is an analytical data model that you build using one of the following:

  • The Power Pivot for Excel 2010 add-in

  • Excel 2013

  • Excel 2016

Applies to:  Power Pivot for SharePoint 2016 | Power Pivot for SharePoint 2013

Server hosting of that data requires SharePoint, Excel Services, and an installation of Power Pivot for SharePoint. Data is loaded on Power Pivot for SharePoint instances where it can be refreshed at scheduled intervals using the Power Pivot data refresh capability that the server provides for Excel 2010 workbooks, that the Power Pivot provides for Excel 2013 and 2016 workbooks.

SQL Server 2016 Power Pivot for SharePoint supports Microsoft SharePoint 2016 and Office Online Server usage of Excel workbooks containing data models and Reporting Services Power View reports.

Excel, within Office Online Server includes data model functionality to enable interaction with a Power Pivot workbook in the browser. You do not need to deploy the Power Pivot for SharePoint 2016 add-in into the farm. You only need to install an Analysis Services server in Power Pivot mode and register the server with Office Online Server.

Deploying the Power Pivot for SharePoint 2016 add-in enables additional functionality and features in your SharePoint farm. The additional features include Power Pivot Gallery and Schedule Data Refresh.

SSAS Power Pivot Mode 3 Server with Office Online Server

SQL Server 2016 Power Pivot for SharePoint supports Microsoft SharePoint 2013 Excel Services usage of Excel workbooks containing data models and Reporting Services Power View reports.

Excel Services in SharePoint 2013 includes data model functionality to enable interaction with a Power Pivot workbook in the browser. You do not need to deploy the Power Pivot for SharePoint 2013 add-in into the farm. You only need to install an Analysis Services server in SharePoint mode and register the server within the Excel Services Data Model settings.

Deploying the Power Pivot for SharePoint 2013 add-in enables additional functionality and features in your SharePoint farm. The additional features include Power Pivot Gallery, Schedule Data Refresh, and the Power Pivot Management Dashboard.

SSAS PowerPivot Mode 2 Server Deployment

Power Pivot Server Administration and Configuration in Central Administration

Power Pivot Configuration using Windows PowerShell

Power Pivot Configuration Tools

Power Pivot Authentication and Authorization

Configure Power Pivot Health Rules

Power Pivot Management Dashboard and Usage Data

Power Pivot Gallery

Power Pivot Data Access

Power Pivot Data Refresh

Power Pivot Data Feeds

Power Pivot BI Semantic Model Connection (.bism)

In other sections

Upgrade Power Pivot for SharePoint

Install Analysis Services in Power Pivot Mode

PowerShell Reference for Power Pivot for SharePoint

Example License Topologies and Costs for SQL Server 2016 Business Intelligence

Power Pivot Planning and Deployment
Disaster Recovery for Power Pivot for SharePoint

Community Additions

ADD
Show:
© 2016 Microsoft