初始組態 (PowerPivot for SharePoint)Initial Configuration (PowerPivot for SharePoint)

您可以使用本主題的步驟,設定 PowerPivot for SharePoint 的初始安裝。Use the steps in this topic to configure an initial installation of PowerPivot for SharePoint. 設定初始安裝最簡單的方式為使用 PowerPivot 組態工具,The easiest way to configure an initial installation is to use the PowerPivot Configuration tool. 以自動化下列所述的各項組態步驟。It automates all of the configuration steps that are described below.

或者,您如果想要對伺服器的設定擁有更多控制權,可以使用管理中心及本主題的資訊,執行各種步驟。Alternatively, if you want more control over how the server is configured, you can use Central Administration and the information in this topic to perform each step individually.

先決條件Prerequisites

SharePoint 伺服器先使用 SharePoint 安裝程式中的伺服器陣列安裝選項加以安裝。The SharePoint server must have been installed using the Server Farm installation option in SharePoint setup. 使用內建資料庫的獨立 SharePoint 伺服器不予支援。A standalone SharePoint server that uses a built-in database is not supported. 如需詳細資訊, 請參閱在 SharePoint 2010 伺服器陣列中使用 SQL SERVER BI 功能的指導方針。For more information, see Guidance for Using SQL Server BI Features in a SharePoint 2010 Farm.

重要

您必須先安裝 SharePoint 2010 SP1,才可設定 PowerPivot for SharePoint 或使用 SQL Server 2012SQL Server 2012 資料庫伺服器的 SharePoint 伺服器陣列。SharePoint 2010 SP1 must be installed before you can configure either PowerPivot for SharePoint, or a SharePoint farm that uses a SQL Server 2012SQL Server 2012 database server. 如果您尚未安裝該 Service Pack,請在開始設定伺服器之前先加以安裝。If you have not yet installed the service pack, do so now before you begin configuring the server.

您必須安裝 PowerPivot for SharePoint。PowerPivot for SharePoint must be installed. 至少必須部署伺服器陣列方案。At a minimum, the farm solution must be deployed. 您可以使用 PowerPivot 組態工具或 PowerShell 指令碼部署伺服器陣列方案。Use either the PowerPivot Configuration tool or PowerShell script to deploy the farm solution. 本主題將提供此步驟的指示。Instructions for this step are provided in this topic.

電腦必須加入網域。The computer must be joined to a domain. 您為服務指定的帳戶必須是網域使用者帳戶。The accounts that you specify for services must be domain user accounts. PowerPivot 服務應用程式至少需要一個網域帳戶。At a minimum, you will need one domain account for the PowerPivot service application. 如果您要設定其他服務 (例如 Excel Services),則每一項提供的服務都應該有個別的帳戶。If you are configuring additional services (such as Excel Services), you should have separate accounts for each service you provision.

您必須是伺服陣列管理員,才能將 PowerPivot for SharePoint 加入到伺服陣列中。You must be a farm administrator to add PowerPivot for SharePoint to the farm. 您必須知道複雜密碼,才可將伺服器及應用程式加入伺服器陣列。You must know the passphrase for adding servers and applications to the farm.

步驟 1:部署 PowerPivot 方案Step 1: Deploy PowerPivot Solutions

您必須安裝及部署伺服器陣列方案及 Web 應用程式方案。There are two solutions that must be installed and deployed: a farm solution and a web application solution.

安裝和部署伺服器陣列方案Install and Deploy the Farm Solution

在前一版中,SQL Server 安裝程式會安裝及部署伺服器陣列方案。In the previous release, SQL Server Setup installed and deployed the farm solution. 在本版中,您必須使用 PowerPivot 組態工具或 PowerShell 指令碼部署伺服器陣列方案。In this release, you must either use the PowerPivot Configuration Tool or PowerShell script to deploy the farm solution. 您無法使用管理中心部署伺服器陣列方案。You cannot use Central Administration to deploy the farm solution. 這是 PowerPivot for SharePoint 組態步驟中,唯一無法在管理中心執行的步驟。This is the only step in PowerPivot for SharePoint configuration that cannot be performed in Central Administration. 部署伺服器陣列方案之後,您即可使用管理中心及本主題的步驟設定 PowerPivot for SharePoint 安裝。After the farm solution is deployed, you can use Central Administration and the steps in this topic to configure a PowerPivot for SharePoint installation.

在此步驟中,您將執行 PowerShell,以安裝及部署伺服器陣列方案。In this step, you run PowerShell to install and deploy the farm solution. 如需詳細資訊, 請參閱使用 Windows PowerShell 的 PowerPivot設定。For more information, see PowerPivot Configuration using Windows PowerShell.

  1. 使用 [以系統管理員身分執行] 選項,開啟 SharePoint 2010 管理命令介面。Open a SharePoint 2010 Management Shell using the Run as Administrator option.

  2. 執行第一個 Cmdlet:Run the first cmdlet:

    Add-SPSolution -LiteralPath "C:\Program Files\Microsoft SQL Server\120\Tools\PowerPivotTools\ConfigurationTool\Resources\PowerPivotFarm.wsp"  
    

    此指令程式會傳回方案的名稱、方案識別碼及 Deployed=False。The cmdlet returns the name of the solution, its solution ID, and Deployed=False. 在下個步驟中,您將部署方案。In the next step, you will deploy the solution.

  3. 執行第二個 Cmdlet 部署方案:Run the second cmdlet to deploy the solution:

    Install-SPSolution -Identity PowerPivotFarm.wsp -GACDeployment -Force  
    

部署 web 應用程式方案Deploy the web application solution

  1. 依序按一下 [開始] 按鈕、[所有程式]、[ Microsoft SharePoint 產品 2010], 然後選取 [ SharePoint 2010 管理中心]。Click the Start button, select All Programs, select Microsoft SharePoint Products 2010, and then select SharePoint 2010 Central Administration.

  2. 在 SharePoint 2010 管理中心的 [系統設定] 中,按一下 [管理伺服陣列方案]In SharePoint 2010 Central Administration, in System Settings, click Manage farm solutions.

    您應該會看到兩個不同的方案套件:powerpivotfarm.wsp 和 powerpivotwebapp.wsp。You should see two separate solution packages: powerpivotfarm.wsp and powerpivotwebapp.wsp. 您必須先完成第一個方案 (powerpivotfarm.wsp) 的部署。The first solution (powerpivotfarm.wsp) must already be deployed. 當其完成部署之後,即無須再行部署。Once it is deployed, it never needs to be deployed again. 第二個方案 (powerpivotwebapp.wsp) 會針對管理中心來部署,但是您必須針對支援 PowerPivot 資料存取的每一個 SharePoint Web 應用程式來手動部署這個方案。The second solution (powerpivotwebapp.wsp) is deployed for Central Administration, but you must deploy this solution manually for each SharePoint web application that will support PowerPivot data access.

  3. 按一下 [powerpivotwebapp.wsp]Click powerpivotwebapp.wsp.

  4. 按一下 [部署方案]。Click Deploy Solution.

  5. 在 [部署至? ] 中, 選取您要加入 PowerPivot 功能支援的 SharePoint web 應用程式。In Deploy To?, select the SharePoint web application to which you want to add PowerPivot feature support.

  6. 按一下 [確定]。Click OK.

  7. 針對其他也支援 PowerPivot 資料存取的 SharePoint Web 應用程式重複以上步驟。Repeat for other SharePoint web applications that will also support PowerPivot data access.

步驟 2:啟動伺服器上的服務Step 2: Start Services on the Server

PowerPivot for SharePoint 部署需要您的伺服器陣列包含下列服務:Excel Calculation Services、Secure Store Service 和對 Windows token 服務的宣告。A PowerPivot for SharePoint deployment requires that your farm include the following services: Excel Calculation Services, Secure Store Service, and Claims to Windows token service.

對於 Excel Services 和 PowerPivot for SharePoint,需要對 Windows Token Service 的宣告。The Claims to Windows Token Service is required for Excel Services and PowerPivot for SharePoint. 它會透過目前 SharePoint 使用者的 Windows 識別,用來建立外部資料來源的連線。It is used to establish connections to external data sources using the Windows identity of the current SharePoint user. 此服務必須在啟用 Excel Services 或 PowerPivot for SharePoint 的每部 SharePoint 伺服器上執行。This service must run on every SharePoint server that has Excel Services or PowerPivot for SharePoint enabled. 如果此服務尚未啟動,您必須立即將它啟動,以便讓 Excel Services 將經過驗證的要求轉送給 PowerPivot 系統服務。If the service is not already started, you must start it now to enable Excel Services to forward authenticated requests to the PowerPivot System Service.

  1. 在管理中心的 [系統設定] 中,按一下 [管理伺服器上的服務]In Central Administration, in System Settings, click Manage services on server.

  2. 啟動對 Windows Token Service 的宣告。Start the Claims to Windows Token Service.

  3. 啟動 Excel Calculation Services。Start Excel Calculation Services.

  4. 啟動 Secure Store Service。Start Secure Store Service.

  5. 確認 SQL Server Analysis Services 和 SQL Server PowerPivot 系統服務都已啟動。Verify that both SQL Server Analysis Services and SQL Server PowerPivot System Service are started.

步驟 3:建立 PowerPivot 服務應用程式Step 3: Create a PowerPivot Service Application

下一步是建立 PowerPivot 服務應用程式。The next step is to create a PowerPivot service application.

  1. 在 [管理中心] 的 [應用程式管理] 中,按一下 [管理服務應用程式]In Central Administration, in Application Management, click Manage service applications.

  2. [服務應用程式] 功能區中,按一下 [新增]In the Service Applications ribbon, click New.

  3. 選取 [ SQL Server PowerPivot 服務應用程式]。Select SQL Server PowerPivot Service Application. 如果它沒有出現在清單中,表示未安裝 PowerPivot for SharePoint 或是未部署此方案。If it does not appear in the list, PowerPivot for SharePoint is not installed or the solution is not deployed.

  4. 在 [建立新的 PowerPivot 服務應用程式] 頁面中, 輸入應用程式的名稱。In the Create New PowerPivot Service Application page, enter a name for the application. 預設值為 new-powerpivotserviceapplication<number >。The default is PowerPivotServiceApplication<number>. 如果您要建立多個 PowerPivot 服務應用程式,描述性名稱將可協助其他系統管理員,了解如何使用應用程式。If you are creating multiple PowerPivot service applications, a descriptive name will help other administrators understand how the application is used.

  5. 在 [應用程式集區] 中,建立新的應用程式集區,並為它選取安全性帳戶。In Application Pool, create a new application pool and select a security account for it. 需要網域使用者帳戶。A domain user account is required.

  6. 在 [資料庫伺服器] 中, 選擇要在其上建立服務應用程式資料庫的資料庫伺服器。In Database Server, choose a database server on which to create the service application database. 預設值是主控伺服陣列組態資料庫的 SQL Server Database Engine 執行個體。The default value is the SQL Server Database Engine instance that hosts the farm configuration databases.

  7. 在 [資料庫名稱] 中, 預設值<為 PowerPivotServiceApplication1_ guid >。In Database Name, the default value is PowerPivotServiceApplication1_<guid>. 預設的資料庫名稱會對應至服務應用程式的預設名稱。The default database name corresponds to the default name of the service application. 如果您輸入唯一的服務應用程式名稱,請依照類似的命名慣例來命名資料庫名稱,以利同時管理它們。If you entered a unique service application name, follow a similar naming convention for your database name so that you can manage them together.

  8. [資料庫驗證] 中,預設值是 Windows 驗證。In Database Authentication, the default is Windows Authentication. 如果您選擇 [SQL 驗證] ,請參考 SharePoint 管理員指南,以了解有關如何在 SharePoint 部署中使用這個驗證類型的最佳作法。If you choose SQL Authentication, refer to the SharePoint administrator guide for best practices on how to use this authentication type in a SharePoint deployment.

  9. 選取 [將這個 PowerPivot 服務應用程式的 Proxy 加入至預設 proxy 群組] 核取方塊。Select the checkbox for Add the proxy for this PowerPivot service application to the default proxy group. 這會將服務應用程式連接加入到預設的服務連接群組。This adds the service application connection to the default service connection group. 預設連接群組中至少必須有一個 PowerPivot 服務應用程式。You must have at least one PowerPivot service application in the default connection group.

    如果 PowerPivot 服務應用程式已經列在預設連接群組中,請勿將第二個服務應用程式加入到該群組。If a PowerPivot service application is already listed in the default connection group, do not add a second service application to that group. 加入預設連接群組的兩個相同類型的服務應用程式並不是支援的組態。Adding two service applications of the same type of the default connection group is not a supported configuration. 如需如何在連接群組中使用其他服務應用程式的詳細資訊, 請參閱在管理中心將 PowerPivot 服務應用程式連接到 SharePoint Web 應用程式For more information about how to use additional service applications in a connection group, see Connect a PowerPivot Service Application to a SharePoint Web Application in Central Administration.

  10. 按一下 [確定].Click OK. 此服務將會與伺服器陣列服務應用程式清單中的其他受管理的服務一起顯示。The service will appear alongside other managed services in the farm's service application list.

步驟 4:啟用 Excel ServicesStep 4: Enable Excel Services

PowerPivot for SharePoint 會要求 Excel Services 支援伺服陣列中的 PowerPivot 資料存取。PowerPivot for SharePoint requires Excel Services to support PowerPivot data access in the farm. 您可以判斷是否已經啟用 Excel Services,其方式是確認 Excel Services 應用程式是否出現在管理中心的服務應用程式清單內。You can determine whether Excel Services is already enabled by confirming whether Excel Services Application appears in the list of service applications in Central Administration. 如果未列出 Excel Services,請立即遵循以下步驟來將它啟用。If Excel Services is not listed, follow these steps to enable it now.

  1. 在 [管理中心] 的 [應用程式管理] 中,按一下 [管理服務應用程式]In Central Administration, in Application Management, click Manage service applications.

  2. 在 [服務應用程式] 功能區的 [建立] 中, 按一下 [新增]。In the Service Applications ribbon, in Create, click New.

  3. 選取 [ Excel Services 應用程式]。Select Excel Services Application.

  4. 在 [建立新的 Excel Services 應用程式] 中,指定名稱 (例如 Excel Services 應用程式)。In Create New Excel Services Application, specify a name (for example, Excel Services Application).

  5. 在 [應用程式集區] 中,選取 [建立新的應用程式集區],並為它提供描述性名稱 (例如 Excel Services 應用程式集區)。In Application Pool, select Create new application pool and give it a descriptive name (for example, Excel Services Application Pool).

  6. 在 [可設定] 中,針對這個應用程式集區識別選取 Windows 網域使用者帳戶。In Configurable, select a Windows domain user account for this application pool identity.

  7. 保留預設核取方塊,將服務應用程式 Proxy 加入到預設的服務連接清單。Keep the default checkbox that adds the service application proxy to the default service connection list.

  8. 按一下 [確定]。Click OK.

  9. 按一下您剛才建立的 Excel Services 應用程式。Click the Excel Services application you just created.

  10. 按一下 [信任的檔案位置], 然後在此頁面上選取您信任的位置。Click Trusted File Locations and on this page, select your trusted location. (一般而言, 這會在 [位址] 資料行中列為HTTP:// )。若要確保 Excel Services 和 PowerPivot 服務可存取活頁簿,您必須將 SharePoint 併入為 Excel Services 信任的位置。(Typically, this is listed as http:// in the Address column.) To ensure that both Excel Services and PowerPivot service have access to the workbook, you must include SharePoint as an Excel Services trusted location. PowerPivot 系統服務無法存取儲存在 SharePoint 伺服陣列外面的活頁簿。PowerPivot System Service cannot access workbooks that are stored outside of a SharePoint farm.

  11. 在 [活頁簿屬性] 區域中, 將 [最大活頁簿大小] 設定為50。In the Workbook Properties area, set Maximum Workbook Size to 50.

  12. 在 [外部資料] 中, 將 [允許外部資料] 設定為信任的資料連線庫和 [內嵌]。In External Data, set Allow External data to Trusted data connection libraries and embedded. 活頁簿中的 PowerPivot 資料存取需要這項設定。This setting is required for PowerPivot data access in a workbook.

  13. 清除 [在資料重新整理時警告] 核取方塊, 以允許預覽 PowerPivot 圖庫中個別工作表的影像。Clear the Warn on Data Refresh checkbox to allow preview images of individual worksheets in PowerPivot Gallery. 如果您選擇保留警告,而活頁簿設定指定在開啟時重新整理,您可能會得到警告的單一預覽影像,而不是活頁簿中的頁面。If you choose to keep the warning and workbook settings specify refresh on open, you might get a single preview image of the warning instead of the pages in your workbook.

  14. 按一下 [確定]。Click OK.

步驟 5:啟用 Secure Store Service 並設定資料重新整理Step 5: Enable Secure Store Service and Configure Data Refresh

PowerPivot for SharePoint 需要 Secure Store Service 來儲存認證和無人看管的執行帳戶,以便重新整理資料。PowerPivot for SharePoint requires Secure Store Service to store credentials and the unattended execution account for data refresh. 您可以判斷是否已經啟用 Secure Store Service,其方式是確認它是否出現在服務應用程式清單內。You can determine whether Secure Store Service is already enabled by confirming whether it appears in the list of service applications.

重要

如果已啟用 Secure Store Service,您仍然應該確認是否已經為它產生主要金鑰。If Secure Store Service is enabled, you should still verify that a master key has been generated for it. 如需指示, 請參閱第2部分:在下列程式中產生主要金鑰。For instructions, see Part 2: Generate the Master Key in the following procedure.

如果未列出 Secure Store Service,請立即遵循以下步驟來將它啟用。If Secure Store Service is not listed, follow these steps to enable it now. 啟用安全存放之後,當活頁簿作者和文件擁有者在排程其發行之活頁簿的資料重新整理時,就可以存取更大範圍的資料來源連接選項。By enabling Secure Store, workbook authors and document owners can access a broader range of data source connection options when scheduling data refresh for their published workbooks.

第 1 部分:啟用 Secure Store ServicePart 1: Enable Secure Store Service
  1. 在 [管理中心] 的 [應用程式管理] 中,按一下 [管理服務應用程式]In Central Administration, in Application Management, click Manage service applications.

  2. 在 [服務應用程式] 功能區的 [建立] 中, 按一下 [新增]。In the Service Applications ribbon, in Create, click New.

  3. 選取 [ Secure Store Service]。Select Secure Store Service.

  4. 在 [建立 Secure Store 應用程式] 頁面中, 輸入應用程式的名稱。In the Create Secure Store Application page, enter a name for the application.

  5. 在 [資料庫] 中, 指定將裝載此服務應用程式之資料庫的 SQL Server 實例。In Database, specify the SQL Server instance that will host the database for this service application. 預設值是主控伺服陣列組態資料庫的 SQL Server Database Engine 執行個體。The default value is the SQL Server Database Engine instance that hosts the farm configuration databases.

  6. 在 [資料庫名稱] 中, 輸入服務應用程式資料庫的名稱。In Database Name, enter the name of the service application database. 預設值為 Secure_Store_Service_DB_<guid >。The default value is Secure_Store_Service_DB_<guid>. 預設名稱會對應至服務應用程式的預設名稱。The default name corresponds to the default name of the service application. 如果您輸入唯一的服務應用程式名稱,請依照類似的命名慣例來命名資料庫名稱,以利同時管理它們。If you entered a unique service application name, follow a similar naming convention for your database name so that you can manage them together.

  7. [資料庫驗證] 中,預設值是 Windows 驗證。In Database Authentication, the default is Windows Authentication. 如果您選擇 [SQL 驗證],請參考 SharePoint 管理員指南,以取得如何在伺服陣列中使用這個驗證類型的指引。If you choose SQL Authentication, refer to the SharePoint administrator guide for guidance on how to use the authentication type in your farm.

  8. 在應用程式集區中, 選取 [建立新應用程式集區]。In Application Pool, select Create new application pool. 指定描述性名稱,將可協助其他伺服器系統管理員識別如何使用應用程式集區。Specify a descriptive name that will help other server administrators identify how the application pool is used.

  9. 選取應用程式集區的安全性帳戶。Select a security account for the application pool. 指定受管理的帳戶,以使用網域使用者帳戶。Specify a managed account to use a domain user account.

  10. 接受其餘的預設值, 然後按一下 [確定]。Accept the remaining default values, and then click OK. 服務應用程式將會和伺服陣列的服務應用程式清單中其他受管理的服務一起並排顯示。The service application will appear alongside other managed services in the farm's service application list.

第 2 部分:產生主要金鑰Part 2: Generate the Master Key
  1. 從清單按一下 Secure Store Service 應用程式。Click the Secure Store Service application from the list.

  2. 在 [服務應用程式] 功能區中, 按一下 [管理]。In the Service Applications ribbon, click Manage.

  3. 在 [金鑰管理] 中, 按一下 [產生新金鑰]。In Key Management, click Generate New Key.

  4. 輸入複雜密碼,然後進行確認。Enter and then confirm a pass phrase. 此複雜密碼將用於加入其他安全存放共用服務應用程式。The pass phrase will be used to add additional secure store shared service applications.

  5. 按一下 [確定]。Click OK.

第 3 部分:設定無人看管的 PowerPivot 資料重新整理帳戶Part 3: Configure the Unattended PowerPivot Data Refresh Account

在資料重新整理期間使用外部資料存取時,通常需要針對 PowerPivot 資料存取建立自動資料重新整理帳戶。Creating an unattended data refresh account for PowerPivot data access is often required for external data access during data refresh. 例如,如果未啟用 Kerberos,您必須建立一個自動帳戶,PowerPivot 服務可以使用此帳戶來連接外部資料來源。For example, if Kerberos is not enabled, you must create an unattended account that the PowerPivot service can use to connect to external data sources.

如需有關如何建立自動 PowerPivot 資料重新整理帳戶或資料重新整理中所用其他預存認證的指示, 請參閱設定 PowerPivot 無人(看管)的資料重新整理帳戶 PowerPivot for SharePoint設定 PowerPivot 資料重新整理(PowerPivot for SharePoint)的預存認證For instructions about how to create the unattended PowerPivot data refresh account or other stored credentials that are used in data refresh, see Configure the PowerPivot Unattended Data Refresh Account (PowerPivot for SharePoint) and Configure Stored Credentials for PowerPivot Data Refresh (PowerPivot for SharePoint).

步驟 6:啟用使用量資料收集Step 6: Enable Usage Data Collection

PowerPivot for SharePoint 會使用 SharePoint 使用量資料收集基礎結構,以蒐集整個伺服陣列中有關 PowerPivot 使用量的資訊。PowerPivot for SharePoint uses the SharePoint usage data collection infrastructure to gather information about PowerPivot usage throughout the farm. 雖然使用量資料一定是 SharePoint 安裝的一部分,但是您可能必須先啟用這個功能才可以使用。Although usage data is always part of a SharePoint installation, you might need to enable it before it can be used. 如需指示, 請參閱設定 PowerPivot for SharePoint 的(使用量資料收集For instructions, see Configure Usage Data Collection for (PowerPivot for SharePoint.

步驟 7:增加 SharePoint Web 應用程式和 Excel Services 的上傳大小上限Step 7: Increase Maximum Upload Size for SharePoint Web Applications and Excel Services

因為 PowerPivot 活頁簿可以很大,所以您可能會想要增加檔案大小上限。Because PowerPivot workbooks can be large, you might want to increase the maximum file size. 有兩個要設定的檔案大小設定:Web 應用程式的最大上傳大小, 以及 Excel Services 中的活頁簿大小上限。There are two file size settings to configure: Maximum Upload Size for the web application, and Maximum Workbook Size in Excel Services. 檔案大小上限應該在兩個應用程式中設定為相同的值。The maximum file size should be set to the same value in both applications. 如需指示, 請參閱設定最大(檔案)上傳大小 PowerPivot for SharePointFor instructions, see Configure Maximum File Upload Size (PowerPivot for SharePoint).

步驟 8:為網站集合啟用 PowerPivot 功能整合Step 8: Activate PowerPivot Feature Integration for Site Collections

網站集合層級的功能啟用可以將應用程式頁面和範本提供給網站使用,包括排程資料重新整理的組態頁面,以及 PowerPivot 圖庫和資料摘要文件庫的應用程式頁面。Feature activation at the site collection level makes application pages and templates available to your sites, including configuration pages for scheduled data refresh and application pages for PowerPivot Gallery and Data Feed libraries.

  1. 按一下 SharePoint 網站上的 [網站動作]。On a SharePoint site, click Site Actions.

    根據預設,SharePoint Web 應用程式會經由通訊埠 80 進行存取。By default, SharePoint web applications are accessed through port 80. 這表示您通常可以藉由輸入 HTTP://<電腦名稱稱 > 來存取 SharePoint 網站, 以開啟根網站集合。This means that you can often access a SharePoint site by entering http://<computer name> to open the root site collection.

  2. 按一下 [站台設定]Click Site Settings.

  3. 按一下 [網站集合管理] 中的 [網站集合功能]。In Site Collection Administration, click Site collection features.

  4. 在您找到PowerPivot 整合網站集合功能之前, 請向下流覽頁面。Scroll down the page until you find PowerPivot Integration Site Collection Feature.

  5. 按一下 [啟用]Click Activate.

  6. 開啟每個網站並按一下 [網站動作],為其他網站集合重複執行。Repeat for additional site collections by opening each site and clicking Site Actions.

如需詳細資訊, 請參閱為管理中心的網站集合啟用 PowerPivot 功能整合For more information, see Activate PowerPivot Feature Integration for Site Collections in Central Administration.

步驟 9:在 SQL Server 2012 PowerPivot for SharePoint 實例上安裝 SQL Server 2008 R2 版的 OLE DB 提供者Step 9: Install the SQL Server 2008 R2 Version of the OLE DB provider on a SQL Server 2012 PowerPivot for SharePoint instance

如果您想要在相同的伺服器上並存執行舊版與新版的 PowerPivot 活頁簿,就必須安裝 Analysis Services OLE DB 提供者,其隨附於 SQL Server 2012SQL Server 2012 PowerPivot for SharePoint 伺服器的 SQL Server 2008 R2 中。If you want to run older and newer versions of PowerPivot workbooks side-by-side on the same server, you must install the Analysis Services OLE DB provider that ships in SQL Server 2008 R2 on a SQL Server 2012SQL Server 2012 PowerPivot for SharePoint server.

安裝提供者可讓參考資料連接字串中 MSOLAP.4 的活頁簿在 SQL Server 2012SQL Server 2012 PowerPivot 伺服器上正常運作。Installing the provider will allow workbooks that reference MSOLAP.4 in the data connection string to work as expected on a SQL Server 2012SQL Server 2012 PowerPivot server. 安裝 SQL Server 2008 R2 OLE DB 提供者是升級舊版 PowerPivot for Excel 所建立之活頁簿的替代方式。Installing the SQL Server 2008 R2 OLE DB provider is an alternative approach to upgrading workbooks that were created in an earlier version of PowerPivot for Excel.

您可以從SQL Server 2008 R2 功能套件 頁面下載提供者。You can download the provider from SQL Server 2008 R2 Feature Pack page. 尋找適用于microsoft® SQL Server® 2008 R2 的 microsoft® Analysis Services OLE DB Provider, 然後下載SQLServer2008_ASOLEDB10.msi安裝程式的 x64 封裝。Look for Microsoft® Analysis Services OLE DB Provider for Microsoft® SQL Server® 2008 R2, and then download the x64 Package of the SQLServer2008_ASOLEDB10.msi installation program.

如需安裝提供者的詳細資訊, 包括驗證步驟, 請參閱在 SharePoint 伺服器上安裝 Analysis Services OLE DB ProviderFor more information about installing the provider, including verification steps, see Install the Analysis Services OLE DB Provider on SharePoint Servers.

步驟 10:確認安裝Step 10: Verify Installation

當使用者或應用程式開啟含有 PowerPivot 資料的 Excel 活頁簿時,就會在伺服陣列中進行 PowerPivot 查詢處理。PowerPivot query processing in the farm occurs when a user or application opens an Excel workbook that contains PowerPivot data. 您至少可以檢查 SharePoint 網站上的頁面,以確認 PowerPivot 功能是可用的。At a minimum, you can check pages on SharePoint sites to verify that PowerPivot features are available. 但是,為了完整確認安裝作業,您必須擁有可以發行到 SharePoint 並從文件庫存取的 PowerPivot 活頁簿。However, to fully verify an installation, you must have a PowerPivot workbook that you can publish to SharePoint and access from a library. 為了測試用途,您可以發行已經包含 PowerPivot 資料的範例活頁簿,並用它來確認 SharePoint 整合已正確設定。For testing purposes, you can publish a sample workbook that already contains PowerPivot data and use it to confirm that SharePoint integration is correctly configured.

若要確認 PowerPivot 可與 SharePoint 網站整合,請執行下列動作:To verify PowerPivot integration with a SharePoint site, do the following:

  1. 在瀏覽器中,開啟您建立的 Web 應用程式。In a browser, open the Web application you created. 如果您使用預設值, 您可以在 URL<位址中指定 HTTP://電腦名稱稱 >。If you used default values, you can specify http://<your computer name> in the URL address.

  2. 確認應用程式中可以使用 PowerPivot 資料存取和處理功能。Verify that PowerPivot data access and processing features are available in the application. 若要這樣做,您可以確認 PowerPivot 提供的文件庫範本是否存在:You can do this by verifying the presence of PowerPivot-provided library templates:

    1. 在 [網站動作] 上, 按一下 [更多選項]。On Site Actions, click More Options...

    2. 在 [程式庫] 中, 您應該會看到資料摘要庫PowerPivot 圖庫In Libraries, you should see Data Feed Library and PowerPivot Gallery. 這些文件庫範本是由 PowerPivot 功能所提供,如果此功能已正確整合,就可以在文件庫清單中看到這些範本。These library templates are provided by the PowerPivot feature and will be visible in the Libraries list if the feature is integrated correctly.

若要在伺服器上確認 PowerPivot 資料存取,請執行以下作業:To verify PowerPivot data access on the server, do the following:

  1. 將 PowerPivot 活頁簿上傳至 PowerPivot 圖庫或任何 SharePoint 文件庫。Upload a PowerPivot workbook to PowerPivot Gallery or any SharePoint library.

  2. 按一下文件,從文件庫中加以開啟。Click on the document to open it from the library.

  3. 按一下交叉分析篩選器或篩選資料來啟動 PowerPivot 查詢。Click on a slicer or filter the data to start a PowerPivot query. 伺服器將會在背景載入 PowerPivot 資料,然後傳回結果。The server will load PowerPivot data in the background and return the results. 在下一個步驟中,您將會連接到伺服器,並確認已經載入及快取資料。In the next step, you will connect to the server to verify the data is loaded and cached.

  4. 在 [開始] 功能表中,從 Microsoft SQL Server 2008 R2 程式群組啟動 SQL Server Management Studio。Start SQL Server Management Studio from the Microsoft SQL Server 2008 R2 program group in the Start menu. 如果伺服器上未安裝這個工具,您可以跳到最後一個步驟,確認快取檔案存在。If this tool is not installed on your server, you can skip to the last step to confirm the presence of cached files.

  5. 在 [伺服器類型] 中,選取 [Analysis Services]。In Server Type, select Analysis Services.

  6. 在 [伺服器名稱] 中, 輸入 <伺服器名稱 > \powerpivot, 其中 <伺服器名稱 > 是具有 PowerPivot for SharePoint 安裝的電腦名稱稱。In Server Name, enter <server-name>\powerpivot, where <server-name> is the name of the computer that has the PowerPivot for SharePoint installation.

  7. 按一下 [連接]Click Connect.

  8. 在物件總管中, 按一下 [資料庫] 以查看已載入的 PowerPivot 資料檔案清單。In Object Explorer, click Databases to view the list of PowerPivot data files that are loaded.

  9. 在電腦檔案系統上,檢查下列資料夾來決定檔案是否要快取到磁碟。On the computer file system, check the following folder to determine whether files are cached to disk. 快取檔案的存在會進一步驗證您的部署是否可以運作。The presence of cached files is further verification that your deployment is operational. 若要檢視檔案快取,請移至 \Program Files\Microsoft SQL Server\MSAS10_50.POWERPIVOT\OLAP\Backup 資料夾。To view the file cache, go to the \Program Files\Microsoft SQL Server\MSAS10_50.POWERPIVOT\OLAP\Backup folder.

後續安裝步驟Post-Installation Steps

在確認安裝之後,請建立 PowerPivot 圖庫或微調個別組態設定來完成服務組態。After you verify the installation, finish service configuration by creating a PowerPivot Gallery or tuning individual configuration settings. 若要充分利用剛才安裝的伺服器元件,您可以下載 PowerPivot for ExcelPowerPivot for Excel 以建立您的第一個 PowerPivot 活頁簿,然後發行。To make full use of the server components you just installed, you can download PowerPivot for ExcelPowerPivot for Excel to create and then publish your first PowerPivot workbook.

安裝用於資料重新整理的資料提供者Install Data Providers Used for Data Refresh

如果您已啟用資料重新整理,伺服器將需要 PowerPivot 用戶端應用程式針對外部資料存取使用的相同資料提供者,才能匯入原始資料 (例如,如果資料原本是使用 32 位元提供者匯入,那麼當伺服器端資料重新整理存取相同的外部資料來源時,也會需要 32 位元提供者)。If you enabled data refresh, the server will need the same data providers for external data access that were used by the PowerPivot client application to import the original data (for example, if the data was originally imported using a 32-bit provider, server-side data refresh will also require the 32-bit provider when it accesses the same external data source). 如需詳細資訊, 請參閱PowerPivot Data Refresh With SharePoint 2010For more information, see PowerPivot Data Refresh with SharePoint 2010.

安裝 ADO.NET Data ServicesInstall ADO.NET Data Services

如果您想要將 SharePoint 清單當做資料摘要匯出,您必須安裝 ADO.NET Data Services 3.5 SP1。You must install ADO.NET Data Services 3.5 SP1 if you want to export SharePoint lists as data feeds. 如需指示, 請參閱Install ADO.NET 資料服務以支援 SharePoint 清單的資料摘要匯出For instructions, see Install ADO.NET Data Services to support data feed exports of SharePoint lists.

PowerPivot 圖庫是一種文件庫,其中包含用來在 SharePoint 網站上檢視 PowerPivot 活頁簿的預覽和呈現選項。PowerPivot Gallery is a library that includes preview and presentation options for viewing PowerPivot workbooks on a SharePoint site. 建議針對它的預覽功能使用 PowerPivot 圖庫來發行及檢視 PowerPivot 活頁簿。Using PowerPivot Gallery to publish and view PowerPivot workbooks is recommended for its preview capability. 此外,如果您也將 Reporting Services 部署到相同的 SharePoint 伺服器,PowerPivot 圖庫可讓您輕鬆建立報表。In addition, if you also deployed Reporting Services to the same SharePoint server, a PowerPivot Gallery provides ease of use in creating reports. 您可以從 PowerPivot 圖庫啟動報表產生器,讓新的報表根據發行的 PowerPivot 活頁簿。You can launch Report Builder from within PowerPivot Gallery to base a new report on a published PowerPivot workbook. 如需建立和使用程式庫的詳細資訊, 請參閱建立和自訂 Powerpivot 圖庫使用 powerpivot 圖庫For more information about creating and using the library, see Create and Customize PowerPivot Gallery and Use PowerPivot Gallery.

在 Excel Services 中建立其他信任的網站Create Additional Trusted Sites in Excel Services

您可以在 Excel Services 中加入信任的網站,以便在提供 Excel 活頁簿和 PowerPivot 資料的網站上變更權限和組態設定。You can add trusted sites in Excel Services to vary permissions and configuration settings on sites that provide Excel workbooks and PowerPivot data. 如需相關資訊,請參閱 Create a trusted location for PowerPivot sites in Central AdministrationFor more information, see Create a trusted location for PowerPivot sites in Central Administration.

微調組態設定Tune Configuration Settings

PowerPivot 服務應用程式是使用預設屬性和值所建立。A PowerPivot service application is created using default properties and values. 您可以修改個別服務應用程式的組態設定,以變更配置要求所依據的方法、設定伺服器逾時、變更查詢回應報告事件的臨界值,或是指定保留使用量資料的時間長度。You can modify configuration settings for individual service applications to change the methodology by which requests are allocated, set server timeouts, change the thresholds for query response report events, or specify how long usage data is retained. 如需有關 [管理中心] 或有關在 SharePoint Web 應用程式中使用 PowerPivot 功能之設定的詳細資訊, 請參閱管理中心的 Powerpivot 伺服器管理和設定。For more information about configuration in Central Administration or about using PowerPivot features in SharePoint Web applications, see PowerPivot Server Administration and Configuration in Central Administration.

安裝 PowerPivot for Excel 及建立 PowerPivot 活頁簿Install PowerPivot for Excel and Build a PowerPivot Workbook

當您在伺服陣列中安裝了伺服器元件之後,您可以先建立使用內嵌 PowerPivot 資料的第一本 Excel 2010 活頁簿,然後將它發行到 Web 應用程式中的 SharePoint 文件庫。After you have the server components installed in a farm, you can create your first Excel 2010 workbook that uses embedded PowerPivot data, and then publish it to a SharePoint library in a Web application. 在您可以建立包含 PowerPivot 資料的 Excel 活頁簿之前,您必須先從安裝 Excel 2010 開始,隨後安裝 PowerPivot for Excel 增益集來擴充 Excel,以支援 PowerPivot 資料匯入和豐富性。Before you can build Excel workbooks that include PowerPivot data, you must start with an installation of Excel 2010, followed by the PowerPivot for Excel add-in that extends Excel to support PowerPivot data import and enrichment.

加入伺服器或應用程式Add Servers or Applications

當您部署 PowerPivot 方案時,將會在網站集合層級針對 Web 應用程式中的所有網站集合啟用功能整合。When you deploy the PowerPivot solution, feature integration is activated at the site collection level for all site collections in the web application. 當您經過一段時間建立新的 Web 應用程式時,您必須將 powerpivotwebapp 方案部署到每一個應用程式。As you create new Web applications over time, you must deploy the powerpivotwebapp solution to each one. 如需指示, 請參閱將 PowerPivot 方案部署到 SharePointFor instructions, see Deploy PowerPivot Solutions to SharePoint.

根據您設定 PowerPivot 服務應用程式的方式而定,PowerPivot 系統服務將會加入到預設連接群組,將它提供給使用預設連接的所有 Web 應用程式使用。Depending on how you configure the PowerPivot service application, the PowerPivot System Service will be added to the default connection group, making it available to all web applications that use default connections. 但是,如果您已設定 Web 應用程式使用自訂服務應用程式連接清單,您需要將 PowerPivot 服務應用程式加入到您想要啟用 PowerPivot 資料處理的每一個 SharePoint Web 應用程式。However, if you configured your Web applications to use custom service application connection lists, you will need to add the PowerPivot service application to each SharePoint web application for which you want to enable PowerPivot data processing. 如需詳細資訊, 請參閱在管理中心將 PowerPivot 服務應用程式連接到 SharePoint Web 應用程式For more information, see Connect a PowerPivot Service Application to a SharePoint Web Application in Central Administration.

一段時間之後,如果您判斷需要額外的資料儲存和處理功能,您可以將另一個 PowerPivot for SharePoint 伺服器執行個體加入到伺服器陣列中。Over time, if you determine that additional data storage and processing capability is needed, you can add a second PowerPivot for SharePoint server instance to the farm. 其安裝程序與您加入第一部伺服器的步驟相同,唯一例外的是您指定執行個體名稱和服務帳戶資訊的需求會不同。The installation process is almost identical to the steps you followed to add the first server, except for requirements in how you specify instance names and service account information. 如需指示, 請參閱部署檢查清單:將 PowerPivot 服務器加入至 SharePoint 2010 伺服器陣列, 以相應放大。For instructions, see Deployment Checklist: Scale-out by adding PowerPivot Servers to a SharePoint 2010 farm.

另請參閱See Also

SQL Server 2014 版本所支援的功能 Features Supported by the Editions of SQL Server 2014
設定 PowerPivot 服務帳戶 Configure PowerPivot Service Accounts
在管理中心建立和設定 PowerPivot 服務應用程式 Create and Configure a PowerPivot Service Application in Central Administration
將 PowerPivot 方案部署到 SharePoint Deploy PowerPivot Solutions to SharePoint
為在 [管理中心] 的 網站集合啟用 PowerPivot 功能整合 Activate PowerPivot Feature Integration for Site Collections in Central Administration
PowerPivot for SharePoint 2010 安裝PowerPivot for SharePoint 2010 Installation