SharePoint 2016 is expected to bring a lot of new and improved features in this release, especially the ones that are already present on SharePoint Online to its On-Premises customers. There are also a list of features that has been either deprecated or removed. In the post, I am only going to talk about What BI Features are Removed in SharePoint 2016.
Deprecated features are not necessarily completely removed. They are included in SharePoint Server 2016 for compatibility with previous product versions. So let’s look at what is removed.
SQL Server BI Combatibility
The SQL Server 2014 add-ins for Power Pivot and Power View will not work with SharePoint Server 2016. You will not be able to deploy or use in SharePoint Server 2016. To deploy these add-ins you need to upgrade to SQL Server 2016 latest build (CTP 3.x Onwards).
Standalone Excel Services have been removed with Excel Online which is a part of Office Web Apps Server. As per the official documentation, the following has been removed:
- Trusted data providers
- Trusted file locations
- Trusted data connection libraries
- Unattended service account
- Excel Services Windows PowerShell cmdlets
- Opening of Excel workbooks from SharePoint Central Administration site
Performance Point in SharePoint 2016
Performance Point has been removed and no more available in SharePoint 2016. The upcoming Power BI Dashboards based on PowerView should be a viable alternative. If you really want Performance Point, you need to go back to SharePoint 2013.
Silverlight is removed with HTML 5
All your Excel PowerPivot and SSRS Reports are now being rendered in HTML. This enables seamless integration with devices of all sizes and cross platform compatibility.
The list might be bigger than what is mentioned here. Please refer to the official Microsoft documentation below: