Business intelligence in SharePoint Server overview

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).