安裝具有 SharePoint 的 SQL Server BI 功能 (PowerPivot 和 Reporting Services)Install SQL Server BI Features with SharePoint (PowerPivot and Reporting Services)

Analysis ServicesAnalysis Services Reporting ServicesReporting Services 可以和 Microsoft SharePoint 伺服器陣列整合,以啟用 SharePoint 中的商業智慧 (BI) 功能。and Reporting ServicesReporting Services can be integrated with a Microsoft SharePoint farm to enable Business Intelligence (BI) features in SharePoint. 功能包括 PowerPivot for SharePointPowerPivot for SharePointPower ViewPower ViewReporting ServicesReporting ServicesThe features include PowerPivot for SharePointPowerPivot for SharePoint, Power ViewPower View, and Reporting ServicesReporting Services. PowerPivot for SharePointPowerPivot for SharePoint 用於 SharePoint 伺服器陣列中的 @no__t 1 資料存取。is used for PowerPivotPowerPivot data access in a SharePoint farm. PowerPivot for SharePointPowerPivot for SharePoint 是一種資料引擎,適用於以 PowerPivotPowerPivot for Excel 建立並從 SharePoint 文件庫存取的活頁簿。is the data engine for workbooks created in PowerPivotPowerPivot for Excel and accessed from a SharePoint library. 當您將 PowerPivotPowerPivot 活頁簿儲存至 SharePoint 之後,即可將其用為 Power ViewPower View 報表的資料來源。Once you save a PowerPivotPowerPivot workbook to SharePoint, you can use it as a data source for Power ViewPower View reports.

SharePoint 2010 所需的一些安裝和組態步驟和 SharePoint 2013 所需要的步驟不同。Some of the installation and configuration steps required for SharePoint 2010 are different than the steps required for SharePoint 2013. 本節的部分主題同時適用於 SharePoint 的這兩個版本。Some of the topics in this section apply to both versions of SharePoint.

適用於:Applies to: SharePoint 2013 | SharePoint 2010適用於:Applies to: SharePoint 2013 | SharePoint 2010

注意如需目前的版本資訊,請參閱SQL server 2014 版本資訊。note For the current release notes, see SQL server 2014 Release Notes.

本主題內容In this topic

本節內容In This Section

除了本主題中的資訊以外,本節內容還包含下列相關主題。In addition to the information in this topic, the following related topics are in this section of content.

SharePoint 中 SQL Server BI 功能的部署拓撲Deployment Topologies for SQL Server BI Features in SharePoint

在 SharePoint 2010 伺服器陣列中使用 SQL Server BI 功能的指引Guidance for Using SQL Server BI Features in a SharePoint 2010 Farm

安裝 BI 功能來搭配 SharePoint 的檢查清單Checklists for Installing BI Features with SharePoint

Reporting Services SharePoint 模式安裝(sharepoint 2010 和 SharePoint 2013)Reporting Services SharePoint Mode Installation (SharePoint 2010 and SharePoint 2013)

PowerPivot for SharePoint 2013 安裝PowerPivot for SharePoint 2013 Installation

PowerPivot for SharePoint 2010 安裝PowerPivot for SharePoint 2010 Installation

SQL Server BI 案例和 SharePoint 2013SQL Server BI Scenarios and SharePoint 2013

本節摘要您可以選擇安裝和設定的不同 BI 功能層級。This section summarizes the different levels of BI features you can choose to install and configure.

SharePoint 2013 中的 Excel Services 包含資料模型功能,可在瀏覽器中啟用與 PowerPivotPowerPivot 活頁簿的互動。Excel Services in SharePoint 2013 includes data model functionality to enable interaction with a PowerPivotPowerPivot workbook in the browser. 針對基本資料模型功能,不需要將 PowerPivot for SharePointPowerPivot for SharePoint 2013 增益集部署至伺服器陣列。For basic data model functionality you do not need to deploy the PowerPivot for SharePointPowerPivot for SharePoint 2013 add-in into the farm. 您只需要在 SharePoint 模式下安裝 Analysis ServicesAnalysis Services 伺服器,並且在 Excel Services [資料模型] 設定中註冊伺服器即可。You only need to install an Analysis ServicesAnalysis Services server in SharePoint mode and register the server within the Excel Services Data Model settings.

部署 PowerPivot for SharePointPowerPivot for SharePoint 2013 增益集可在 SharePoint 伺服器陣列中啟用其他功能與特性。Deploying the PowerPivot for SharePointPowerPivot for SharePoint 2013 add-in enables additional functionality and features in your SharePoint farm. 其他功能包括 PowerPivotPowerPivot 圖庫、排程資料重新整理及 PowerPivot 管理儀表板。The additional features include PowerPivotPowerPivot Gallery, Schedule Data Refresh, and the PowerPivot Management Dashboard. 請參閱下表以取得其他資訊。See the table for additional information.

層級Level 功能Features 安裝或設定Install or Configure
11 僅 SharePointSharePoint Only 原生 Excel Services 功能Native Excel Services Features Excel Services 以及 SharePoint Server 2013 隨附的其他服務。Excel Services and other services included with SharePoint Server 2013.
22 SharePoint 以及 SharePoint 模式的 Analysis ServicesSharePoint with Analysis Services in SharePoint Mode 在瀏覽器中的互動式 PowerPivot 活頁簿Interactive PowerPivot workbooks in the browser 以 SharePoint 模式安裝 Analysis ServicesAnalysis ServicesInstall Analysis ServicesAnalysis Services in SharePoint mode.

在 Excel Services 中註冊 Analysis Services 伺服器。Register Analysis Services Server in Excel Services.
33 SharePoint 以及 SharePoint 模式的 Reporting ServicesSharePoint with Reporting Services in SharePoint Mode Power ViewPower View 以 SharePoint 模式安裝 Reporting ServicesReporting ServicesInstall Reporting ServicesReporting Services in SharePoint mode.

安裝適用于 SharePoint 的 Reporting ServicesReporting Services 增益集 (rssharepoint.msi .msi)Install Reporting ServicesReporting Services add-in (rsSharePoint.msi) for SharePoint. 如需詳細資訊,請參閱安裝或卸載適用(于 sharepoint SharePoint 2010 和 sharepoint 2013)的 Reporting Services 增益集For more information, see Install or Uninstall the Reporting Services Add-in for SharePoint (SharePoint 2010 and SharePoint 2013)
44 所有 PowerPivot 功能All PowerPivot Features 存取活頁簿做為來自於伺服器陣列外部的資料來源。Access to workbooks as a data source from outside the farm.

排程資料重新整理。Schedule Data refresh.

PowerPivot 圖庫。PowerPivot Gallery.

管理儀表板。Management Dashboard.

BISM 連結檔案內容類型。BISM link file content type.
部署 PowerPivot for SharePoint 2013 增益集 (sppowerpivot.msi .msi)Deploy PowerPivot for SharePoint 2013 add-in (spPowerPivot.msi). 如需詳細資訊,請參閱下列內容:For more information, see the following:

安裝或卸載 PowerPivot for SharePoint 增益集(SharePoint 2013)Install or Uninstall the PowerPivot for SharePoint Add-in (SharePoint 2013)

如需有關如何下載 spPowerPivot.msi的詳細資訊,請參閱< 下載 SQL Server 2014 PowerPivot for SharePoint>。For information see on how to download spPowerPivot.msi, see Download SQL Server 2014 PowerPivot for SharePoint.

如需啟用 @no__t 0 功能的詳細資訊,請參閱SharePoint 2013 的 SQL SERVER BI 新故事https://blogs.msdn.com/b/analysisservices/archive/2012/07/27/introducing-the-bi-light-up-story-for-sharepoint-2013.aspx) 。For additional information on enabling Analysis ServicesAnalysis Services features, see The SQL Server BI Light-Up Story for SharePoint 2013 (https://blogs.msdn.com/b/analysisservices/archive/2012/07/27/introducing-the-bi-light-up-story-for-sharepoint-2013.aspx).

安裝的總覽Overview of Installation

如果您要同時使用 PowerPivot for SharePointPowerPivot for SharePointReporting ServicesReporting Services,請執行 [SQL Server 安裝精靈] 兩次。If you want to use both PowerPivot for SharePointPowerPivot for SharePoint and Reporting ServicesReporting Services, run SQL Server Installation Wizard twice. 在 [SQL Server 安裝程式] 的 [安裝程式角色] 頁面上,Reporting ServicesReporting ServicesPowerPivotPowerPivot 是不同的選擇。Reporting ServicesReporting Services and PowerPivotPowerPivot are separate choices on the Setup Role page of the SQL Server setup wizard.

PowerPivot for SharePointPowerPivot for SharePoint 支援 SharePoint 2010 和 SharePoint 2013。不過,視 SharePoint 的版本而定,所使用的架構和安裝程序會有所不同。supports both SharePoint 2010 and SharePoint 2013; however a different architecture and installation process is used depending on the version of SharePoint.

以下將摘要說明在單一伺服器上部署 SQL Server 2014SQL Server 2014 BI 功能的安裝步驟:The following is a summary of the installation steps to deploy SQL Server 2014SQL Server 2014 BI Features on a single server:

PowerPivot for SharePointPowerPivot for SharePoint 2013PowerPivot for SharePointPowerPivot for SharePoint 2013

若為 SharePoint 2013,可以在未安裝 SharePoint 產品的伺服器上執行 PowerPivot for SharePointPowerPivot for SharePoint 安裝。For SharePoint 2013, the PowerPivot for SharePointPowerPivot for SharePoint installation can be run on a server that does not have a SharePoint product installed. 適用於 SharePoint 2013 的 PowerPivotPowerPivot 架構是在 SharePoint 伺服器陣列 執行,因此可以安裝在包含 SharePoint 安裝的伺服器上,也可以安裝在不包含 SharePoint 安裝的伺服器上。The PowerPivotPowerPivot architecture used for SharePoint 2013, runs outside the SharePoint farm and can either be installed on a server that also contains a SharePoint installation or it can be installed a server that does NOT contains a SharePoint installation.

  1. 安裝 SharePoint Server 2013 並啟用 Excel Services。Install SharePoint Server 2013 and enable Excel Services.

  2. 以 SharePoint 模式安裝 Analysis ServicesAnalysis Services ,並且在 Analysis ServicesAnalysis Services中,將伺服器管理員權限授與 SharePoint 伺服器陣列及服務帳戶。Install Analysis ServicesAnalysis Services in SharePoint mode, and grant the SharePoint farm and services accounts server administrator rights in Analysis ServicesAnalysis Services.

    對於 SharePoint 的這兩個版本, PowerPivotPowerPivot 安裝程序一開始都會先在 SQL Server 安裝精靈中選取 [SQL Server PowerPivot for SharePoint] 安裝程式角色,或者使用 SQL Server 命令提示字元安裝。For both versions of SharePoint, the PowerPivotPowerPivot installation process starts by selecting the setup role of SQL Server PowerPivot for SharePoint in the SQL Server Installation wizard or use a SQL Server command prompt installation.

    安裝程式角色Setup Role

  3. 若為 SharePoint 2013,您可以擴充 PowerPivotPowerPivot 功能和體驗。For SharePoint 2013, you can extend the PowerPivotPowerPivot features and experience. 下載並執行 spPowerPivot.msi ,以加入對 PowerPivotPowerPivot 活頁簿的伺服器端資料重新整理處理、共同作業和管理支援。Download and run spPowerPivot.msi to add server-side data refresh processing, collaboration, and management support for PowerPivotPowerPivot workbook. 如需詳細資訊,請參閱< Microsoft SQL Server 2014 PowerPivot for Microsoft® SharePoint>。For more information, see Microsoft SQL Server 2014 PowerPivot for Microsoft® SharePoint.

    在 SharePoint 伺服陣列中的每個伺服器上執行 PowerPivot for SharePointPowerPivot for SharePoint 2013 安裝套件 spPowerPivot.msi ,以確保安裝正確的資料提供者版本。Run the PowerPivot for SharePointPowerPivot for SharePoint 2013 installation package spPowerPivot.msi on each server in the SharePoint farm to ensure the correct version of the data providers are installed.

  4. 若要設定 PowerPivotPowerPivot for SharePoint 2013,請使用 [PowerPivot for SharePoint 2013 組態] 工具。To configure PowerPivotPowerPivot for SharePoint 2013, use PowerPivot for SharePoint 2013 Configuration tool.

    SQL Server 安裝精靈會安裝兩個 PowerPivotPowerPivot 組態工具。The SQL Server installation wizard installs two PowerPivotPowerPivot Configurations tools. 其中一個組態工具支援 SharePoint 2013,另一個工具則支援 SharePoint 2010。One of the configuration tools supports SharePoint 2013 and the other tool supports SharePoint 2010.

    兩個 PowerPivot 組態工具two powerpivot configuratoin tools

  5. 在 SharePoint Server 2013 中設定 Excel Services,以使用 Analysis ServicesAnalysis Services 執行個體。Configure Excel Services in SharePoint Server 2013 to use the Analysis ServicesAnalysis Services instance. 如需詳細資訊,請參閱PowerPivot for SharePoint 2013 安裝中的「設定基本 Analysis Services SharePoint 整合」一節,以及管理 Excel Services 資料模型設定(SharePoint Server 2013)https://technet.microsoft.com/library/jj219780.aspx) 。For more information, see the section "Configure Basic Analysis Services SharePoint Integration" in PowerPivot for SharePoint 2013 Installation.and Manage Excel Services data model settings (SharePoint Server 2013) (https://technet.microsoft.com/library/jj219780.aspx).

  6. 如需詳細資訊,請參閱< PowerPivot for SharePoint 2013 Installation>。For more information, see PowerPivot for SharePoint 2013 Installation.

PowerPivot for SharePointPowerPivot for SharePoint 2010PowerPivot for SharePointPowerPivot for SharePoint 2010

若為 SharePoint 2010,則需要在已經安裝或將會安裝 SharePoint 2010 的伺服器上執行 PowerPivotPowerPivot for SharePoint 安裝。For SharePoint 2010, it is required that the PowerPivotPowerPivot for SharePoint Installation is run on a server that already has SharePoint 2010 installed or will be installed. 適用於 SharePoint 2010 的 PowerPivotPowerPivot 架構是在伺服器陣列 執行,所以 SharePoint 必須位於安裝 PowerPivotPowerPivot for SharePoint 的伺服器上。The PowerPivotPowerPivot architecture for SharePoint 2010 runs inside the farm and requires SharePoint on the server that PowerPivotPowerPivot for SharePoint is installed.

  1. 以 SharePoint 模式安裝 Analysis ServicesAnalysis Services ,並且在 Analysis ServicesAnalysis Services中,將伺服器管理員權限授與 SharePoint 伺服器陣列及服務帳戶。Install Analysis ServicesAnalysis Services in SharePoint mode, and grant the SharePoint farm and services accounts server administrator rights in Analysis ServicesAnalysis Services.

    SharePoint 2010 部署不支援 spPowerPivot.msi,使用 SharePoint 2010 時 需要此 .msi。A SharePoint 2010 deployment does not support spPowerPivot.msi, and the .msi is not required with SharePoint 2010.

    對於 SharePoint 的這兩個版本, PowerPivotPowerPivot 安裝程序一開始都會先在 SQL Server 安裝精靈中選取 [SQL Server PowerPivot for SharePoint] 安裝程式角色,或者使用 SQL Server 命令提示字元安裝。For both versions of SharePoint, the PowerPivotPowerPivot installation process starts by selecting the setup role of SQL Server PowerPivot for SharePoint in the SQL Server Installation wizard or use a SQL Server command prompt installation.

  2. SQL Server 安裝精靈會安裝兩個 PowerPivotPowerPivot 組態工具。The SQL Server installation wizard installs two PowerPivotPowerPivot Configurations tools. 其中一個組態工具支援 SharePoint 2013,另一個工具則支援 SharePoint 2010。One of the configuration tools supports SharePoint 2013 and the other tool supports SharePoint 2010.

    若要設定 PowerPivotPowerPivot for SharePoint 2010,請使用 [PowerPivot 組態工具]To configure PowerPivotPowerPivot for SharePoint 2010, use the PowerPivot Configuration Tool .

  3. 如需詳細資訊,請參閱< PowerPivot for SharePoint 2010 Installation>。For more information, see PowerPivot for SharePoint 2010 Installation.

Reporting ServicesReporting Services for SharePoint 2010 和 2013Reporting ServicesReporting Services for SharePoint 2010 and 2013

  1. SharePoint 模式中的 Reporting ServicesReporting Services 安裝和舊版一樣並沒有變更。The installation for Reporting ServicesReporting Services in SharePoint mode is unchanged from the previous release.

    SharePoint 2010 和 SharePoint 2013 的 Reporting ServicesReporting Services 安裝步驟非常類似。The Reporting ServicesReporting Services installation steps for SharePoint 2010 and SharePoint 2013 are very similar. 有關 SharePoint 版本的重要注意事項如下:Important notes regarding SharePoint versions are:

    1. 以 SharePoint 模式安裝 Reporting ServicesReporting ServicesInstall Reporting ServicesReporting Services in SharePoint mode. Reporting Services sharepoint 模式安裝(sharepoint 2010 和 SharePoint 2013) ,並安裝適用于 sharepoint 2010 的 Reporting Services sharepoint 模式Reporting Services SharePoint Mode Installation (SharePoint 2010 and SharePoint 2013) and Install Reporting Services SharePoint Mode for SharePoint 2010.

    2. 安裝 SharePoint 產品的 Reporting ServicesReporting Services 增益集 (rsSharePoint.msi)。Install the Reporting ServicesReporting Services add-in for SharePoint products (rsSharePoint.msi). 請參閱安裝或卸載適用(于 sharepoint SharePoint 2010 和 sharepoint 2013)的 Reporting Services 增益集See Install or Uninstall the Reporting Services Add-in for SharePoint (SharePoint 2010 and SharePoint 2013). 如需適用于 SharePoint 的 Reporting ServicesReporting Services 增益集的最新版本,請參閱尋找適用于 Sharepoint 產品之 Reporting Services 增益集的位置For the current version of the Reporting ServicesReporting Services add-in for SharePoint, see Where to find the Reporting Services add-in for SharePoint Products.

    3. 設定 Reporting ServicesReporting Services SharePoint 服務以及至少一個 Reporting ServicesReporting Services 服務應用程式。Configure the Reporting ServicesReporting Services SharePoint service and at least one Reporting ServicesReporting Services service application. 如需詳細資訊,請參閱Install Reporting Services Sharepoint Mode For sharepoint 2013中的「建立 Reporting Services 服務應用程式」一節。For more information, see the section "Create a Reporting Services Service Application" in Install Reporting Services SharePoint Mode for SharePoint 2013.

資料庫附加升級和 SharePoint 2013 的總覽Overview of Database-attach Upgrade and SharePoint 2013

SharePoint 2013 不支援就地升級。SharePoint 2013 does not support in-place upgrade. 不過, 支援資料庫附加升級However database-attach upgrade is supported.

如果您擁有與 SharePoint 2010 整合的現有 PowerPivot 安裝,就無法就地升級 SharePoint 伺服器。If you have an existing PowerPivot installation integrated with SharePoint 2010, you cannot in-place upgrade the SharePoint server. 不過,您可以在 SharePoint 資料庫附加升級中完成下列步驟:However, you can complete the following steps as part of a SharePoint database-attach upgrade:

  1. 安裝新的 SharePoint Server 2013 伺服器陣列。Install a new SharePoint Server 2013 farm.

  2. 完成 SharePoint 資料庫附加升級,並且將 PowerPivot 相關的內容資料庫移轉至 SharePoint 2013 伺服器陣列。Complete a SharePoint database-attach upgrade, and migrate your PowerPivot related content databases to the SharePoint 2013 farm.

  3. 以 SharePoint 模式安裝 SQL Server Analysis Services 執行個體,並將 Analysis ServicesAnalysis Services伺服器管理員權限授與 SharePoint 伺服器陣列與服務帳戶。Install an instance of SQL Server Analysis Services in SharePoint mode and grant the SharePoint farm and services accounts, server administrator rights in Analysis ServicesAnalysis Services.

  4. 在 SharePoint 伺服器陣列中的每部伺服器上安裝 PowerPivot for SharePoint 2013 安裝套件 spPowerPivot.msiInstall the PowerPivot for SharePoint 2013 installation package spPowerPivot.msi on each server in the SharePoint farm.

  5. 在 SharePoint 2013 管理中心內,將 Excel Services 設定為使用以 SharePoint 模式執行的 Analysis Services 伺服器 (在步驟 3 中建立)。In SharePoint 2013 Central Administration, configure Excel Services to use the Analysis Services server running in SharePoint mode created in step 3.

    若要移轉重新整理排程,請設定 PowerPivot 服務應用程式。To migrate refresh schedules, configure the PowerPivot service application.

注意

如需有關 PowerPivot 和 SharePoint 資料庫附加升級的詳細資訊,請參閱下列主題:For more information on PowerPivot and SharePoint database-attach upgrade, see the following:

另請參閱See Also

尋找適用於 SharePoint 產品之 Reporting Services 增益集的位置 Where to find the Reporting Services add-in for SharePoint Products
支援的 SharePoint 和 Reporting Services 伺服器與增益集(的組合 SQL Server 2014) Supported Combinations of SharePoint and Reporting Services Server and Add-in (SQL Server 2014)
安裝或卸載適用于 SharePoint (sharepoint 2010 和 sharepoint 2013 的 Reporting Services 增益集)Install or Uninstall the Reporting Services Add-in for SharePoint (SharePoint 2010 and SharePoint 2013)