Business intelligence in SharePoint Server

2/23/2018 2 minutes to read In this article APPLIES TO: 2013 2016 2019 SharePoint 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 […]


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

Next Post

Commercial Auto Insurance | Progressive Commercial

Sun Mar 22 , 2020
Commercial auto insurance for small business We’re the #1 commercial auto insurer in America*, insuring more than 1 million commercial vehicles Commercial auto insurance is liability and physical damage protection for vehicles, such as cars, trucks and vans, that are used for business. Commercial vehicles require a separate policy because […]

You May Like