White Paper Published: Deploying SQL Server 2016 PowerPivot and Power View in SharePoint 2016
The PowerPivot add-in for SharePoint Server 2016 was published for the first time as part of the Microsoft SQL Server 2016 Community Technology Preview (CTP) 3.1 Feature Pack. Now customers can take advantage of SharePoint 2016 in their I-enabled farms and benefit from infrastructure advancements, compliance and security enhancements, and numerous performance and reliability improvements. For all the details, see the SharePoint Server 2016 Beta 2 online documentation at https://technet.microsoft.com/en-us/library/cc303422(v=office.16).aspx.
Especially the changes in Excel Services, now called Excel Online, have significant impact on the deployment of a BI-enabled farm. Unifying both workbook editing and BI scenarios, Excel Online no longer exists in SharePoint, but is co-deployed on a separate computer running Office Online Server. This new architecture introduces new dependencies, such as the need to configure Kerberos Constrained Delegation (KCD) because Excel Online must be able to act on behalf of the user when opening a workbook in the browser that uses another workbook as its data source.
Tags: sharepoint, tabular