Site icon

Updates for Excel Services and BI in SharePoint 2016 on-premises

If your organization enables Excel Services for SharePoint to enable BI, we have some updates on what has changed with SharePoint Server 2016 BI. Updates include architecture changes to the SharePoint-based on-premises Microsoft BI Stack and how you can benefit from upgrading your BI farms to SharePoint Server 2016, SQL 2016 and Office Online Server with Excel Online. We also examine various aspects, such as upgradeability, backward compatibility and licensing. For more information, please read “Deploying SQL Server 2016 PowerPivot and Power View in SharePoint 2016.”

First, let’s look at the history of Excel web solutions on-premises:

From the diagram above, you can see that Excel Services has evolved from an optional add-on application for SharePoint Server 2007 to an inherent part of Office Online Server for on-premises. In this newest 2016 release, Excel Services capabilities are moving to Office Online Server (which used to be called Office Web Apps Server) and as a result Excel Services is being replaced with Office Online Server.

Here is a summary of the main benefits brought to you by moving to Office Online Server and the latest and greatest version of Excel in your BI deployment. Many of these benefits are not limited to BI scenarios, but are valuable in other setups as well.

Here is a look at the architecture of the Microsoft BI Stack 2016 for on-premises:

Key facts

The following list summarizes key facts about our on-premises offering in Microsoft BI Stack 2016 release.

SharePoint Server 2016 licensing also incurred changes. First, SharePoint Server 2016 no longer offers the Foundation SKU. It now comes only in Standard and Enterprise SKUs, with Standard CAL and Enterprise CAL licenses. Second, licensing requirements for some SharePoint Insights features have been relaxed. Namely, accessing external data, refreshing and working with a Model is now possible with all SharePoint SKUs, but advanced capabilities such as PowerPivot for SharePoint add-in, Reporting Services add-in, Excel Web Parts and ODC file support will still require SharePoint Enterprise CAL.

Key facts

The following list summarizes key facts about our SharePoint Server 2016 licensing changes:

With the new SharePoint 2016 release and Office Online Server, we’ve completed the move toward a unified architecture for viewing and editing Excel workbooks using Office Online Server. Moving to the new architecture provides users with access to the latest and greatest Excel features and adds new BI-specific features, such as search in PivotTable filters, and helps IT unify the deployment around one farm of Excel servers instead of two. In addition, we’ve simplified the licensing model, and you can expect Excel to be evergreen and keep getting new capabilities on a regular basis.

Please tell us what you think by commenting below.

—The Excel team

The post Updates for Excel Services and BI in SharePoint 2016 on-premises appeared first on Office Blogs.

Exit mobile version