Business intelligence in SharePoint Server

2/23/2018 2 minutes to read

APPLIES TO: yes2013 yes2016 no2019 noSharePoint Online

Learn about the Microsoft business intelligence (BI) tools for SharePoint Server 2016 and SharePoint Server 2013.

Requirements for SharePoint Server 2016 BI is that Microsoft SQL Server 2016 RTM is required. If you want to use Microsoft SQL Server Power Pivot for SharePoint or Microsoft Power View for SharePoint you must install the Power Pivot or Power View add-ins for SQL Server 2016 RTM. This requirement also applies to using Microsoft SQL Server Analysis Services (SSAS) and Microsoft SQL Server Reporting Services (SSRS) with SharePoint Server 2016. You must install SQL Server 2016 Analysis Services (SSAS) and SQL Server 2016 Reporting Services (SSRS).

Power Pivot for SharePoint Server 2013 is only available with SQL Server 2012 SP1 Analysis Services (SSAS).

Note that to use the business intelligence (BI) tools in SharePoint Server 2013 you must install SQL Server 2012 with Service Pack 1 (SP1) or SQL Server 2014, 64-bit version. For more information, see Hardware and software requirements for SharePoint Server 2016.

See also

Install SQL Server 2016 Business Intelligence Features

SharePoint 2016 and SQL 2016 Business Intelligence

Editions and Components of SQL Server 2016

Features Supported by the Editions of SQL Server 2016

Integration Services Features Supported by the Editions of SQL Server 2016

BI and analytics

Source Article