Freigeben über

White Paper Published: Deploying SQL Server 2016 PowerPivot and Power View in SharePoint 2016

  • Artikel

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.

Here’s what you need to get started:

Also make sure you download and read the white paper Deploying SQL Server 2016 PowerPivot and Power View in SharePoint 2016 because it provides a first overview of the architecture changes and corresponding new system architecture for SQL Server BI based on SharePoint 2016 and Office Online Server. It also outlines a recommended deployment path to enable and verify BI capabilities in a SharePoint 2016 farm in three main stages. This white paper also guides you past certain known issues that exist in the SharePoint Server 2016 Beta 2, Office Online Server Preview and SQL Server 2016 CTP 3.1 releases.

The main goal of this white paper is to help you get familiar with the new architecture as quickly as possible by focusing on the essential deployment tasks in a small demo environment. Subsequent papers and blog articles will build on this foundation, such as when covering the scale-out of a BI environment or complex authentication scenarios. Stay tuned!

Comments

  • Anonymous
    December 09, 2015
    Any update on when PowerView may be available without Silverlight?

  • Anonymous
    December 09, 2015
    Hi Chris, Right now the focus is entirely on wrapping up SQL Server 2016, but post RTM, we are going to work on improvements for self-service BI and other areas. Cheers, Kay

  • Anonymous
    December 09, 2015
    Is PowerView also HTLM5 or still relies on SilverLight (which is not enabled on Edge, Chrome..)

  • Anonymous
    December 09, 2015
    Power View still requires Silverlight.

  • Anonymous
    December 15, 2015
    By the way, why not use the new "Power Pivot" name as two separate words everywhere? ;) That would make it consistent with the name used in Excel 2016 and SQL Server 2016: msdn.microsoft.com/.../ee210692.aspx support.office.com/.../Power-Pivot-Powerful-data-analysis-and-data-modeling-in-Excel-d7b119ed-1b3b-4f23-b634-445ab141b59b

  • Anonymous
    December 15, 2015
    You're right Alex. I should have used the new spelling. Old habits...

  • Anonymous
    January 06, 2016
    I thought they were moving away from SharePoint and going back to Native for their portal of choice...that's what we have been told.

  • Anonymous
    January 06, 2016
    Nah, SharePoint is and remains important.

  • Anonymous
    May 17, 2016
    The comment has been removed

    • Anonymous
      October 25, 2016
      Good morning, I am getting the same error..Does anyone know if there is an updated installation procedure for server 2016, sharepoint 2016 with SQL 2016 an office online server?Final versions have been released but no documentation updates???

  • Anonymous
    August 02, 2016
    White paper link goes to a 404.

    • Anonymous
      November 30, 2016
      Mh, works for me. If you continue to have this issue, perhaps search the Web just for the document name.