Deploy PowerPivot and Power View - Multi-Tier SharePoint 2016 Farm

APPLIES TO: yesSQL Server Analysis Services noAzure Analysis Services

Summary: Summary: This white paper provides SharePoint administrators and architects detailed step-by-step instructions for deploying and configuring a Microsoft BI demo environment in a SharePoint farm with multiple servers, based on the Preview releases of SharePoint Server 2016, Office Online Server, and the SQL Server 2016 BI stack for SharePoint 2016. Following a brief introduction of important architecture changes and corresponding system dependencies, it outlines software and configuration requirements and a recommended deployment path to enable and verify BI capabilities in three main stages. This white paper also addresses known issues that exist in the SharePoint Server 2016 Beta 2, Office Online Server Preview and SQL Server 2016 CTP 3.1 releases and suggests appropriate workarounds. These workarounds will no longer be necessary in the final versions of the products. Check for an updated version of this white paper when deploying RTM releases.

**Writer:**Kay Unkroth, Jason Haak

Technical Reviewers: Adam Saxton, Anne Zorner, Craig Guyer, Frank Weigel, Gregory Appel, Heidi Steen, Kasper de Jonge, Kirk Stark, Klaus Sobel, Mike Plumley, Mike Taghizadeh, Patrick Wheeler, Riccardo Muti, Steve Hord

**Published:**January, 2016

Applies to: SQL Server 2016 CTP3.1, SharePoint 2016 Preview, Office Online Server Preview

To review the document, please download the Deploying SQL Server 2016 PowerPivot and Power View in a Multi-Tier SharePoint 2016 Farm Word document.