升級 Power Pivot for SharePointUpgrade Power Pivot for SharePoint

適用於: 是SQL Server (僅限 Windows) 否Azure SQL Database 否Azure SQL 資料倉儲 否平行處理資料倉儲 APPLIES TO: yesSQL Server (Windows only) noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

本文摘要說明將 PowerPivot for SharePointPower Pivot for SharePoint 部署升級至 Microsoft SQL Server 2016 Power Pivot for SharePointMicrosoft SQL Server 2016 Power Pivot for SharePoint 所需的步驟。This article summarizes the steps required to upgrade a deployment of PowerPivot for SharePointPower Pivot for SharePoint to Microsoft SQL Server 2016 Power Pivot for SharePointMicrosoft SQL Server 2016 Power Pivot for SharePoint. 特定步驟取決於您環境目前執行的 SharePoint 版本,並包含 Power PivotPower Pivot for SharePoint 增益集 (spPowerPivot.msi)。The specific steps depend on the version of SharePoint your environment is currently running and include the Power PivotPower Pivot for SharePoint Add-in (spPowerPivot.msi).

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

如需版本資訊,請參閱 SQL Server 2016 版本資訊For release notes, see SQL Server 2016 Release Notes.

本文內容:In this article:

必要條件Prerequisites

升級現有的 SharePoint 2013 伺服器陣列Upgrade an Existing SharePoint 2013 Farm

升級現有的 SharePoint 2010 伺服器陣列Upgrade an Existing SharePoint 2010 Farm

活頁簿Workbooks

資料重新整理Data Refresh

驗證 Power Pivot 元件和服務的版本Verify the Versions of Power Pivot Components and Services

在 SharePoint 伺服器陣列中升級多部 Power Pivot for SharePoint 伺服器Upgrading Multiple Power Pivot for SharePoint Servers in a SharePoint Farm

將 QFE 套用至伺服器陣列中的 Power Pivot 執行個體Applying a QFE to a Power Pivot instance in the farm

升級後的驗證工作Post-upgrade verification tasks

背景Background

  • 如果您要升級含有兩個 (含) 以上 PowerPivot for SharePointPower Pivot for SharePoint 執行個體的多伺服器 SharePoint 2010 伺服器陣列,必須在繼續升級下一部伺服器 之前 ,完整升級每部伺服器。If you are upgrading a multi-server SharePoint 2010 farm that has two or more PowerPivot for SharePointPower Pivot for SharePoint instances, you must fully upgrade each server before continuing to the next server. 完整升級包括執行 SQL Server 安裝程式來升級 PowerPivot for SharePointPower Pivot for SharePoint 程式檔案,然後再執行 SharePoint 升級動作來設定已升級的服務。A full upgrade includes running SQL Server Setup to upgrade PowerPivot for SharePointPower Pivot for SharePoint program files, followed by SharePoint upgrade actions that configure the upgraded services. 在適當的 Power PivotPower Pivot 組態工具或 Windows PowerShell 中執行升級動作之前,伺服器可用性會受到限制。Server availability will be limited until you run upgrade actions in the appropriate Power PivotPower Pivot Configuration Tool or Windows PowerShell.

  • SharePoint 2010 伺服陣列中 Power PivotPower Pivot 系統服務與 Analysis Services 的所有執行個體版本必須都一樣。All instances of Power PivotPower Pivot System Service and Analysis Services in a SharePoint 2010 farm must be the same version. 如需如何驗證版本的資訊,請參閱本文的驗證 Power Pivot 元件和服務的版本一節。For information on how to verify the version, see the section Verify the Versions of Power Pivot Components and Services in this article.

  • Power PivotPower Pivot 組態工具是 SQL Server 共用功能之一,所有共用功能都會同時升級。The Power PivotPower Pivot configuration tools are one of the SQL Server shared features and all shared features upgrade at the same time. 如果您在升級過程中選取需要共用功能升級的其他 SQL Server 執行個體或功能,則 Power PivotPower Pivot 組態工具也會一併升級。If during an upgrade process you select other SQL Server instances or features that require a shared feature upgrade, then the Power PivotPower Pivot configuration tool will also be upgraded. 如果升級 Power PivotPower Pivot 組態工具但未升級 Power PivotPower Pivot 執行個體,可能會發生問題。You may have issues if the Power PivotPower Pivot configuration tool is upgraded but your Power PivotPower Pivot instance is not. 如需 SQL Server 共用功能的詳細資訊,請參閱使用安裝精靈升級為 SQL Server 2016 (安裝程式)For more information about SQL Server shared features, see Upgrade to SQL Server 2016 Using the Installation Wizard (Setup).

  • Power PivotPower Pivot for SharePoint 增益集 (spPowerPivot.msi) 會與舊版並存安裝。The Power PivotPower Pivot for SharePoint Add-in (spPowerPivot.msi) installs side by side with previous versions. 例如, SQL Server 2017SQL Server 2017 增益集會安裝至資料夾 c:\Program Files\Microsoft SQL Server\130\Tools\PowerPivotToolsFor example the SQL Server 2017SQL Server 2017 add-in installs to the folder c:\Program Files\Microsoft SQL Server\130\Tools\PowerPivotTools.

必要條件Prerequisites

PermissionsPermissions

  • 您必須是伺服器陣列管理員,才能升級 Power PivotPower Pivot for SharePoint 安裝。You must be a farm administrator to upgrade a Power PivotPower Pivot for SharePoint installation. 您必須是本機系統管理員,才能執行 SQL Server 安裝程式。You must be a local administrator to run SQL Server Setup.

  • 您必須要有伺服器陣列組態資料庫的 db_owner 權限。You must have db_owner permissions on the farm configuration database.

SQL Server:SQL Server:

  • 如果現有的 Power PivotPower Pivot 安裝為 SQL Server 2008 R2SQL Server 2008 R2,則需要 SQL Server 2008 R2SQL Server 2008 R2 Service Pack 2 (SP2),才能升級至 SQL Server 2017SQL Server 2017 PowerPivot for SharePointPower Pivot for SharePointIf the existing Power PivotPower Pivot installation is SQL Server 2008 R2SQL Server 2008 R2, the SQL Server 2008 R2SQL Server 2008 R2 Service Pack 2 (SP2) is required for an upgrade to SQL Server 2017SQL Server 2017 PowerPivot for SharePointPower Pivot for SharePoint.

  • 如果現有的 Power PivotPower Pivot 安裝為 SQL Server 2012 (11.x)SQL Server 2012 (11.x),則需要 SQL Server 2012 (11.x)SQL Server 2012 (11.x) Service Pack 1 (SP1),才能升級至 SQL Server 2017SQL Server 2017 PowerPivot for SharePointPower Pivot for SharePointIf the existing Power PivotPower Pivot installation is SQL Server 2012 (11.x)SQL Server 2012 (11.x), the SQL Server 2012 (11.x)SQL Server 2012 (11.x) Service Pack 1 (SP1) is required for an upgrade to SQL Server 2017SQL Server 2017 PowerPivot for SharePointPower Pivot for SharePoint.

SharePoint 2010:SharePoint 2010:

  • 如果現有的安裝是執行 SharePoint 2010,請先安裝 SharePoint 2010 Service Pack 2,再升級至 SQL Server 2017SQL Server 2017PowerPivot for SharePointPower Pivot for SharePointIf the existing installation is running SharePoint 2010, install the SharePoint 2010 Service Pack 2 before upgrading to SQL Server 2017SQL Server 2017PowerPivot for SharePointPower Pivot for SharePoint. 如需詳細資訊,請參閱< Service Pack 2 for Microsoft SharePoint 2010>。For more information, see Service Pack 2 for Microsoft SharePoint 2010. 使用 PowerShell 命令 (Get-SPfarm).BuildVersion.ToString() 來驗證版本。Use the PowerShell command (Get-SPfarm).BuildVersion.ToString() to verify the version. 若要將組建版本參照至發行日期,請參閱< SharePoint 2010 組建編號>。To reference the build version to release date, see SharePoint 2010 Build Numbers.

升級現有的 SharePoint 2013 伺服器陣列Upgrade an Existing SharePoint 2013 Farm

若要將部署在 SharePoint 2013 中的 PowerPivot for SharePointPower Pivot for SharePoint 升級,請執行下列動作:To upgrade PowerPivot for SharePointPower Pivot for SharePoint deployed in SharePoint 2013, do the following:

PowerPivot for SharePoint 2013 升級powerpivot for sharepoint 2013 upgrade

  1. 在以 SharePoint 模式執行 SQL Server 2017SQL Server 2017 的後端伺服器上,執行 Analysis ServicesAnalysis Services 安裝程式。Run SQL Server 2017SQL Server 2017 Setup on backend server(s) that run Analysis ServicesAnalysis Services in SharePoint mode. 如果該伺服器主控多個 Analysis ServicesAnalysis Services執行個體,則至少要升級 POWERPIVOT 執行個體。If the server hosts multiple instances of Analysis ServicesAnalysis Services, upgrade at least the POWERPIVOT instance. 下列清單是有關 Power PivotPower Pivot 升級的安裝精靈步驟摘要:The following list is a summary of setup wizard steps related to a Power PivotPower Pivot upgrade:

    1. 在 [ SQL ServerSQL Server 安裝精靈] 中,按一下 [安裝]In the SQL ServerSQL Server Setup Wizard, click Installation.

    2. 按一下 [從 SQL Server 升級...] 。Click Upgrade from SQL Server......

    3. [選取執行個體] 頁面上,選取 [POWERPIVOT] 執行個體名稱,然後按 [下一步]On the Select Instance page, select the POWERPIVOT instance name and then click Next.

    4. 如需詳細資訊,請參閱使用安裝精靈升級為 SQL Server 2016 (安裝程式)For more information, see Upgrade to SQL Server 2016 Using the Installation Wizard (Setup)

  2. 重新啟動伺服器。Restart the server.

  3. 在 SharePoint 2013 伺服器陣列中的每部伺服器上,執行 Power PivotPower Pivot for SharePoint 增益集 (spPowerPivot.msi),以安裝資料提供者。Run the Power PivotPower Pivot for SharePoint add-in (spPowerPivot.msi) on each server in the SharePoint 2013 farm to install the data providers. 但是執行 SQL Server 安裝精靈所在的伺服器除外,安裝精靈也會升級資料提供者。The exception is servers where you ran the SQL Server setup wizard, which also upgrades data providers. 如需詳細資訊,請參閱下載 Microsoft SQL Server 2014 Powerpivot for Microsoft SharePoint 2013安裝或解除安裝 Power Pivot for SharePoint 增益集 (SharePoint 2013)For more information, see Download Microsoft SQL Server 2014 Power Pivot for Microsoft SharePoint 2013 and Install or Uninstall the Power Pivot for SharePoint Add-in (SharePoint 2013).

  4. 在 SharePoint 2013 伺服器陣列中的每部伺服器上,執行 Power PivotPower Pivot for SharePoint 2013 組態 工具,以增益集所安裝的更新方案檔來設定 SharePoint 伺服器陣列。Run the Power PivotPower Pivot for SharePoint 2013 Configuration tool on one of the SharePoint application servers to configure the SharePoint farm with the updated solution files that the add-in installed. 您無法使用 SharePoint 管理中心來進行此步驟。You cannot use Central SharePoint Administration for this step. 如需詳細資訊,請參閱下列內容:For more information, see the following:

    1. 在 Windows [開始] 頁面中,輸入 Power PivotPower Pivot ,然後在搜尋結果中,按一下 [Power PivotPower Pivot for SharePoint 2013 組態] 。From the Windows Start page, type Power PivotPower Pivot and in the search results, click Power PivotPower Pivot for SharePoint 2013 Configuration. 請注意,搜尋可能會將組態工具的兩個版本皆傳回。Note the search may return both versions of the configuration tool.

      兩個 PowerPivot 組態工具two powerpivot configuratoin tools

      Or

      在 [開始] 功能表上,指向 [所有程式] ,然後依序按一下 [Microsoft SQL Server 2017Microsoft SQL Server 2017]、[組態工具] 和 [Power PivotPower Pivot for SharePoint 2013 組態工具] 。On the Start menu, point to All Programs, click Microsoft SQL Server 2017Microsoft SQL Server 2017, click Configuration Tools, and then click Power PivotPower Pivot for SharePoint 2013 Configuration Too. 請注意,只有在本機伺服器上安裝了 PowerPivot for SharePointPower Pivot for SharePoint 時,才會列出此工具。Note that this tool is listed only when PowerPivot for SharePointPower Pivot for SharePoint is installed on the local server.

    2. 啟動時,組態工具會檢查 Power PivotPower Pivot 伺服器陣列方案與 Power PivotPower Pivot Web 應用程式方案的升級狀態。At startup, the configuration tool checks the upgrade status of the Power PivotPower Pivot farm solution and Power PivotPower Pivot web application solutions. 如果偵測到這些方案的舊版,您將看到「偵測到較新版本的 Power PivotPower Pivot 方案檔。請選取升級選項以升級您的伺服器陣列」。If older versions of these solutions are detected, you will see the message "Newer versions of the Power PivotPower Pivot solution files have been detected. Please select the upgrade option to upgrade your farm." 按一下 [確定] 以關閉系統驗證訊息。Click OK to close the system validation message.

    3. 按一下 [升級功能、服務、應用程式和方案] ,然後按一下 [確定]Click Upgrade Features, Services, Applications and Solutions, and then click OK.

    4. 檢閱左窗格工作清單中的動作,並排除您不希望該工具執行的任何動作。Review the actions in the left pane task list and exclude any that you do not want the tool to perform. 預設包含所有動作。All actions are included by default. 若要移除動作,請在左邊工作清單中選取該動作,然後清除 [參數] 頁面上的 [在工作清單中包含這個動作] 核取方塊。To remove an action, select it in the left task list, and then on the Parameters page, clear the Include this action in the task list checkbox.

    5. 或者,在 [指令碼][輸出] 索引標籤中檢閱詳細資訊。Optionally, review detailed information in the Script or Output tab.

      [輸出] 索引標籤是此工具即將執行之動作的摘要。The Output tab is a summary of the actions that will be performed by the tool. 此資訊會儲存在記錄檔中: C:\Program Files\Microsoft SQL Server\130\Tools\PowerPivotTools\SPAddinConfiguration\LogThis information is saved in log files at C:\Program Files\Microsoft SQL Server\130\Tools\PowerPivotTools\SPAddinConfiguration\Log.

      [指令碼] 索引標籤會顯示 PowerShell 指令程式,或參考此工具將執行的 PowerShell 指令碼檔案。The Script tab shows the PowerShell cmdlets or references the PowerShell script files that the tool will run.

    6. 按一下 [驗證] 來檢查每個動作是否有效。Click Validate to check whether each action is valid. 如果無法使用 [驗證] ,表示所有動作都適用於您的系統。If Validate is not available, it means that all of the actions are valid for your system. 如果可以使用 [驗證] ,表示您可能已經修改輸入值 (例如,Excel 服務應用程式名稱),或此工具可能已經判定府執行特定動作。If Validate is available, you might have modified an input value (for example, the Excel service application name), or the tool might have determined that a particular action cannot be performed. 如果無法執行某個動作,您必須排除該動作,或修正造成此動作標示為無效的基礎條件。If an action cannot be performed, you must exclude it or fix the underlying conditions that cause the action to be flagged as invalid.

      重要

      您必須一律先處理第一個動作 [升級伺服器陣列方案]The first action, Upgrade Farm Solution, must always be processed first. 此動作會註冊用來設定伺服器的 PowerShell 指令程式。It registers the PowerShell cmdlets that are used to configure the server. 如果此動作出現錯誤,請不要繼續。If you get an error on this action, do not continue. 在處理工作清單中的其他動作之前,請改用此錯誤所提供的資訊診斷並解決問題。Instead, use the information provided by the error to diagnose and resolve the problem before processing additional actions in the task list.

    7. 按一下 [執行] ,執行適用於此工作的所有動作。Click Run to perform all of the actions that are valid for this task. 只有在通過驗證檢查的情況下,才可以使用 [執行]Run is available only after the validation check is passed. 當您按一下 [執行] 時,會出現下列警告,提醒您動作是在批次模式下處理:「工具中標示為有效的所有組態設定都會套用到 SharePoint 伺服器陣列。您要繼續嗎?When you click Run, the following warning appears, reminding you that actions are processed in batch mode: "All of the configuration settings that are flagged as valid in the tool will be applied to the SharePoint farm. Do you want to continue?".

    8. 按一下 [是] 繼續。Click Yes to continue.

    9. 在伺服器陣列中升級方案和功能可能需要數分鐘才能完成。Upgrading solutions and features in the farm can take several minutes to complete. 在這段期間內,Power PivotPower Pivot 資料的連接要求將會失敗,並出現類似下列錯誤:「無法重新整理資料」或「嘗試執行要求的動作時發生錯誤。請再試一次」。During this time, connection requests for Power PivotPower Pivot data will fail with errors similar to "Unable to refresh data" or "An error has occurred trying to perform the requested action. Please try again." 升級完成後,伺服器將會變成可以使用,而且將不再發生這些錯誤。After upgrade is finished, the server will become available and these errors will no longer occur.

    如需詳細資訊,請參閱下列內容:For more information, see the following:

  5. 透過執行升級後步驟以及檢查伺服器陣列中的 Power PivotPower Pivot 伺服器版本,來確認升級成功。Verify that upgrade succeeded by performing the post-upgrade steps and by checking the version of Power PivotPower Pivot servers in the farm. 如需詳細資訊,請參閱本文的升級後的驗證工作和下列章節:For more information, see Post-upgrade verification tasks in this article and the following section.

升級現有的 SharePoint 2010 伺服器陣列Upgrade an Existing SharePoint 2010 Farm

若要將部署在 SharePoint 2010 中的 PowerPivot for SharePointPower Pivot for SharePoint 升級,請執行下列動作:To upgrade PowerPivot for SharePointPower Pivot for SharePoint deployed in SharePoint 2010, do the following:

PowerPivot for SharePoint 2010 升級powerpivot for sharepoint 2010 upgrade

  1. 下載 Service Pack 2 for Microsoft SharePoint 2010 ,並套用至伺服器陣列中的所有伺服器。Download Service Pack 2 for Microsoft SharePoint 2010 and apply it on all servers in the farm. 確認 SharePoint SP2 安裝成功。Verify that SharePoint SP2 installation succeeded. 在管理中心的 [升級與移轉] 頁面上,開啟 [檢查產品與修補安裝狀態] 頁面,以檢視與 SP2 相關的狀態訊息。In Central Administration, on the Upgrade and Migration page, open the Check product and patch installation status page to view status messages related to SP2.

  2. 確認 SharePoint 2010 Administration Windows 服務正在執行中。Verify that the SharePoint 2010 Administration Windows service is running.

    Get-Service | where {$_.displayname -like "*SharePoint*"}  
    
  3. 確認 SharePoint 管理中心已經啟動 SharePoint 服務、SQL Server Analysis ServicesSQL Server Power PivotPower Pivot 系統服務,或使用下列 PowerShell 命令:Verify the SharePoint services SQL Server Analysis Services and SQL Server Power PivotPower Pivot System Service are started in SharePoint Central Administration or use the following PowerShell command:.

    get-SPserviceinstance | where {$_.typename -like "*sql*"}  
    
  4. 確認 Windows 服務 SQL Server Analysis Services (Power PivotPower Pivot) 正在執行。Verify the Windows service SQL Server Analysis Services (Power PivotPower Pivot) is running.

    Get-Service | where {$_.displayname -like "*powerpivot*"}  
    
  5. 在執行 SQL Server Analysis Services (Power PivotPower Pivot) Windows 服務的第一部 SharePoint 應用程式伺服器上,執行 SQL Server 2017SQL Server 2017 安裝程式,以升級 POWERPIVOT 執行個體。Run SQL Server 2017SQL Server 2017 Setup on the first SharePoint application server that runs the SQL Server Analysis Services (Power PivotPower Pivot) Windows service to upgrade the POWERPIVOT instance. 在 [SQL Server 安裝精靈] 的 [安裝] 頁面上,選擇升級選項。On the Installation page of the SQL Server Setup Wizard, choose the upgrade option. 如需詳細資訊,請參閱 使用安裝精靈升級為 SQL Server 2016 (安裝程式)For more information, see Upgrade to SQL Server 2016 Using the Installation Wizard (Setup).

  6. 在執行組態工具之前,請先重新啟動伺服器Restart the server before running the configuration tool. 此步驟可確保 SQL Server 安裝程式安裝的任何更新或必要條件完全在系統上設定。This step ensures that any updates or prerequisites installed by SQL Server Setup are fully configured on the system.

  7. 在 SharePoint 2013 伺服器陣列中的每部伺服器上,執行 Power PivotPower Pivot ) 服務的第一部 SharePoint 應用程式伺服器上, 組態工具Power PivotPower Pivot,以升級 SharePoint 中的方案和 Web 服務。Run the Power PivotPower Pivot Configuration Tool on the first SharePoint application server that runs SQL Server Analysis Services (Power PivotPower Pivot) service to upgrade the solutions and Web services in SharePoint. 您無法使用管理中心進行此步驟。You cannot use Central Administration for this step.

    1. 在 [開始] 功能表上,指向 [所有程式] ,然後依序按一下 [Microsoft SQL Server 2017Microsoft SQL Server 2017]、[組態工具] 及 [Power PivotPower Pivot 組態工具] 。On the Start menu, point to All Programs, click Microsoft SQL Server 2017Microsoft SQL Server 2017, click Configuration Tools, and then click Power PivotPower Pivot Configuration Tool. 請注意,只有在本機伺服器上安裝了 PowerPivot for SharePointPower Pivot for SharePoint 時,才會列出此工具。Note that this tool is listed only when PowerPivot for SharePointPower Pivot for SharePoint is installed on the local server.

    2. 啟動時,組態工具會檢查 Power PivotPower Pivot 伺服器陣列方案與 Power PivotPower Pivot Web 應用程式方案的升級狀態。At startup, the configuration tool checks the upgrade status of the Power PivotPower Pivot farm solution and Power PivotPower Pivot web application solutions. 如果偵測到這些方案的舊版,您將看到「偵測到較新版本的 Power PivotPower Pivot 方案檔。If older versions of these solutions are detected, you will see the message "Newer versions of the Power PivotPower Pivot solution files have been detected. 請選取升級選項以升級您的伺服器陣列」。Please select the upgrade option to upgrade your farm." 按一下 [確定] 以關閉訊息。Click OK to close the message.

    3. 按一下 [升級功能、服務、應用程式和方案] ,然後按一下 [確定] 繼續。Click Upgrade Features, Services, Applications and Solutions, and then click OK to continue.

    4. 會出現下列警告:「Power PivotPower Pivot 管理儀表板中的活頁簿即將升級為最新版本。The following warning appears: "Workbooks in the Power PivotPower Pivot Management Dashboard are about to be upgraded to the latest version. 您對現有活頁簿所做的任何自訂內容都將遺失。Any customizations you made to the existing workbooks will be lost. 您要繼續嗎?」Do you want to continue?"

      此警告指的是 Power PivotPower Pivot 管理儀表板中,針對資料重新整理活動報告的活頁簿。This warning refers to workbooks in the Power PivotPower Pivot Management Dashboard that report on data refresh activity. 如果您自訂這些活頁簿,當現有的檔案取代成較新的版本時,您對這些活頁簿所做的任何變更都會遺失。If you customized these workbooks, any changes you made to those workbooks will be lost when existing files are replaced with newer versions.

      按一下 [是] ,將活頁簿覆寫成較新的版本。Click Yes to overwrite the workbooks with newer versions. 否則,按一下 [否] ,返回首頁。Otherwise, click No to return to the home page. 將活頁簿儲存到不同的位置,讓您擁有一個副本,然後在準備好繼續時,返回此步驟。Save the workbooks to a different location so that you have a copy, and then return to this step when you are ready to continue.

      如需自訂儀表板中使用之活頁簿的詳細資訊,請參閱 自訂 Power Pivot 管理儀表板For more information about customizing workbooks used in the dashboard, see Customizing the Power Pivot Management Dashboard.

    5. 檢閱工作清單中的動作,並排除您不希望該工具執行的任何動作。Review the actions in the task list and exclude any that you do not want the tool to perform. 預設包含所有動作。All actions are included by default. 若要移除動作,請在工作清單中選取該動作,然後清除 [參數] 頁面上的 [在工作清單中包含這個動作] 核取方塊。To remove an action, select it in the task list, and then clear the Include this action in the task list checkbox on the Parameters page.

    6. 或者,在 [輸出] 索引標籤或 [指令碼] 索引標籤中檢閱詳細資訊。Optionally, review detailed information in the Output tab or Script tab.

      [輸出] 索引標籤是此工具即將執行之動作的摘要。The Output tab is a summary of the actions that will be performed by the tool. 此資訊會儲存在記錄檔中: c:\Program Files\Microsoft SQL Server\130\Tools\PowerPivotTools\ConfigurationTool\LogThis information is saved in log files at c:\Program Files\Microsoft SQL Server\130\Tools\PowerPivotTools\ConfigurationTool\Log.

      [指令碼] 索引標籤會顯示 PowerShell 指令程式,或參考此工具將執行的 PowerShell 指令碼檔案。The Script tab shows the PowerShell cmdlets or references the PowerShell script files that the tool will run.

    7. 按一下 [驗證] 來檢查每個動作是否有效。Click Validate to check whether each action is valid. 如果無法使用 [驗證] ,表示所有動作都適用於您的系統。If Validate is not available, it means that all of the actions are valid for your system. 如果可以使用 [驗證] ,表示您可能已經修改輸入值 (例如,Excel 服務應用程式名稱),或此工具可能已經判定府執行特定動作。If Validate is available, you might have modified an input value (for example, the Excel service application name), or the tool might have determined that a particular action cannot be performed. 如果無法執行某個動作,您必須排除該動作,或修正造成此動作標示為無效的基礎條件。If an action cannot be performed, you must exclude it or fix the underlying conditions that cause the action to be flagged as invalid.

      重要

      您必須一律先處理第一個動作 [升級伺服器陣列方案]The first action, Upgrade Farm Solution, must always be processed first. 此動作會註冊用來設定伺服器的 PowerShell 指令程式。It registers the PowerShell cmdlets that are used to configure the server. 如果此動作出現錯誤,請不要繼續。If you get an error on this action, do not continue. 在處理工作清單中的其他動作之前,請改用此錯誤所提供的資訊診斷並解決問題。Instead, use the information provided by the error to diagnose and resolve the problem before processing additional actions in the task list.

    8. 按一下 [執行] ,執行適用於此工作的所有動作。Click Run to perform all of the actions that are valid for this task. 只有在通過驗證檢查的情況下,才可以使用 [執行]Run is available only after the validation check is passed. 當您按一下 [執行] 時,會出現下列警告,提醒您動作是在批次模式下處理:「工具中標示為有效的所有組態設定都會套用到 SharePoint 伺服器陣列。When you click Run, the following warning appears, reminding you that actions are processed in batch mode: "All of the configuration settings that are flagged as valid in the tool will be applied to the SharePoint farm. 您要繼續嗎?」Do you want to continue?"

    9. 按一下 [是] 繼續。Click Yes to continue.

    10. 在伺服器陣列中升級方案和功能可能需要數分鐘才能完成。Upgrading solutions and features in the farm can take several minutes to complete. 在這段期間內,Power PivotPower Pivot 資料的連接要求將會失敗,並出現如下的錯誤:「無法重新整理資料」或「嘗試執行要求的動作時發生錯誤。During this time, connection requests for Power PivotPower Pivot data will fail with errors like "Unable to refresh data" or "An error has occurred trying to perform the requested action. 請再試一次」。Please try again." 升級完成後,伺服器將會變成可以使用,而且將不再發生這些錯誤。After upgrade is finished, the server will become available and these errors will no longer occur.

  8. 針對伺服器陣列中的每個 SQL Server Analysis Services (Power PivotPower Pivot) 服務重複此程序:1) 執行 SQL Server 安裝程式 2) 執行 Power PivotPower Pivot 組態工具。Repeat the process for each SQL Server Analysis Services (Power PivotPower Pivot) service in the farm: 1) Run SQL Server setup 2) Run the Power PivotPower Pivot Configuration tool.

  9. 透過執行升級後步驟以及檢查伺服器陣列中的 Power PivotPower Pivot 伺服器版本,來確認升級成功。Verify that upgrade succeeded by performing the post-upgrade steps and by checking the version of Power PivotPower Pivot servers in the farm. 如需詳細資訊,請參閱本文的升級後的驗證工作和下列章節:For more information, see Post-upgrade verification tasks in this article and the following section.

  10. 疑難排解錯誤Troubleshooting errors

    您可以在 [參數] 窗格中檢視每個動作的錯誤資訊。You can view error information in the Parameters pane for each action.

    針對與方案部署或撤銷相關的問題,請確認已啟動 SharePoint 2010 Administrator 服務。For problems related to solution deployment or retraction, verify the SharePoint 2010 Administrator service is started. 此服務會執行觸發伺服器陣列中組態變更的計時器作業。This service runs the timer jobs that trigger configuration changes in a farm. 如果該服務未執行,方案部署或撤銷將會失敗。If the service is not running, solution deployment or retraction will fail. 持續性錯誤指的是現有的部署或撤銷作業已經在佇列中,因此會攔截組態工具的其他動作。Persistent errors indicate that an existing deployment or retraction job is already in the queue and blocking further action from the configuration tool.

    1. 以管理員身分啟動 SharePoint 2010 管理命令介面,然後執行下列命令來檢視佇列中的作業:Start the SharePoint 2010 Management Shell as an administrator and then run the following command to view jobs in the queue:

      Stsadm -o enumdeployments  
      
    2. 檢閱現有部署的下列資訊:[類型] 是 [撤銷] 或 [部署]、[檔案] 是 powerpivotwebapp.wsp 或 powerpivotfarm.wsp。Review existing deployments for the following information: Type is Retraction or Deployment, File is powerpivotwebapp.wsp or powerpivotfarm.wsp.

    3. 若是與 Power PivotPower Pivot 方案相關的部署或撤銷,請複製 JobId 的 GUID 值,然後將其貼入下列命令 (使用命令介面之 [編輯] 功能表上的 [標記]、[複製] 和 [貼上] 命令來複製 GUID):For deployments or retractions related to Power PivotPower Pivot solutions, copy the GUID value for JobId and then paste it into the following command (use the Mark, Copy, and Paste commands on the Shell's Edit menu to copy the GUID):

      Stsadm -o canceldeployment -id "<GUID>"  
      
    4. 依序按一下 [驗證][執行] ,重試組態工具中的工作。Retry the task in the configuration tool by clicking Validate followed by Run.

    至於其他所有錯誤,請檢查 ULS 記錄檔。For all other errors, check the ULS logs. 如需詳細資訊,請參閱設定及檢視 SharePoint 記錄檔與診斷記錄 (Power Pivot for SharePoint)For more information, see Configure and View SharePoint Log Files and Diagnostic Logging (Power Pivot for SharePoint).

活頁簿Workbooks

升級伺服器不一定會升級伺服器上執行的 Power PivotPower Pivot 活頁簿,但是使用舊版 Power PivotPower Pivot for Excel 建立的舊活頁簿仍可如常運作,並使用該版本提供的功能。Upgrading a server does not necessarily upgrade the Power PivotPower Pivot workbooks that run on it, but older workbooks created in the previous version of Power PivotPower Pivot for Excel will continue to work as before, using the features available in that release. 活頁簿可以維持運作,是由於已升級的伺服器具有屬於舊版安裝的 Analysis Services OLE DB 提供者版本所致。Workbooks remain functional because an upgraded server has the version of the Analysis Services OLE DB provider that was part of the previous installation.

資料重新整理Data Refresh

升級會影響資料重新整理作業。Upgrade will impact data refresh operations. 伺服器的排程資料重新整理僅適用於符合伺服器版本的活頁簿。Scheduled data refresh on the server is available only for workbooks that match the server version. 如果您裝載舊版的活頁簿,資料重新整理可能不再適用於這些活頁簿。If you are hosting workbooks from the previous version, data refresh might no longer work for those workbooks. 若要重新啟用資料重新整理,您必須升級活頁簿。To re-enable data refresh, you must upgrade the workbooks. 您可以在 Power PivotPower Pivot for Excel 中手動升級每個活頁簿,或是針對 SharePoint 2010 中的資料重新整理功能啟用自動升級。You can upgrade each workbook manually in Power PivotPower Pivot for Excel, or enable the auto-upgrade for data refresh feature in SharePoint 2010. 自動升級會在執行資料重新整理之前將活頁簿升級為最新版本,讓資料重新整理作業依排程執行。Auto-upgrade will upgrade a workbook to the current version prior to running data refresh, allowing data refresh operations to remain on schedule.

驗證 Power Pivot 元件和服務的版本Verify the Versions of Power Pivot Components and Services

Power PivotPower Pivot 系統服務和 Analysis Services 的所有執行個體必須是相同版本。All instances of Power PivotPower Pivot System Service and Analysis Services must be the same version. 若要確認所有伺服器元件都是相同的版本,請檢查以下版本資訊:To verify that all server components are at the same version, check version information for the following:

驗證 Power Pivot 方案和 Power Pivot 系統服務的版本Verify the version of Power Pivot Solutions and the Power Pivot System Service

執行下列 PowerShell 命令:Run the following PowerShell command:

Get-PowerPivotSystemService  

驗證 CurrentSolutionVersionVerify the CurrentSolutionVersion. SQL Server 2017SQL Server 2017 是 13.0.<主要組建>.<次要組建> 版is version 13.0.<major build>.<minor build>

驗證 Analysis Services Windows 服務的版本Verify the version of the Analysis Services Windows Service

如果您只有升級 SharePoint 2010 伺服陣列中的部分 PowerPivot for SharePointPower Pivot for SharePoint 伺服器,則未升級之伺服器上的 Analysis ServicesAnalysis Services 執行個體將會比預期在伺服器陣列中的版本還舊。If you upgraded only some of your PowerPivot for SharePointPower Pivot for SharePoint servers in a SharePoint 2010 farm, the instance of Analysis ServicesAnalysis Services on un-upgraded servers will be older than the version expected in the farm. 您必須將所有的伺服器升級至相同版本,才可以加以使用。You will need to upgrade all of your servers to the same version in order for them to be usable. 使用下列其中一種方法來驗證每部電腦上的 SQL Server Analysis Services (Power PivotPower Pivot) Windows 服務版本。Use one of the following methods to verify the version of the SQL Server Analysis Services ( Power PivotPower Pivot) Windows service on each computer.

Windows 檔案總管Windows File Explorer:

  1. 瀏覽至 Bin 資料夾,尋找 Power PivotPower Pivot 執行個體。Navigate to the Bin folder for the Power PivotPower Pivot instance. 例如 C:\Program Files\Microsoft SQL Server\MSAS13.POWERPIVOT\OLAP\binFor example C:\Program Files\Microsoft SQL Server\MSAS13.POWERPIVOT\OLAP\bin.

  2. 以滑鼠右鍵按一下 msmdsrv.exe,然後選取 [屬性]Right-click msmdsrv.exe, and select Properties.

  3. 按一下 [詳細資料]Click Details.

  4. SQL Server 2017SQL Server 2017 檔案版本應該為 13.00.<主要組建>.<次要組建>。file version should be 13.00.<major build>.<minor build>.

  5. 確認這個編號與 Power PivotPower Pivot 方案和系統服務版本相同。Verify that this number is identical to the Power PivotPower Pivot solution and system service version.

服務啟動資訊:Service start information:

Power PivotPower Pivot 服務啟動時,會將版本資訊寫入 Windows 事件記錄檔。When the Power PivotPower Pivot service starts, it writes version information into the Windows event log.

  1. 執行 Windows eventvwrRun Windows eventvwr

  2. 建立來源 MSOLAP$POWERPIVOT的篩選。Create a filter for source MSOLAP$POWERPIVOT.

  3. 尋找類似下列的資訊層級事件Look for an information level event similar to the following

    服務已啟動。Service started. Microsoft SQL Server Analysis Services 64 位元 Evaluation (x64) RTM 13.0.2000.8Microsoft SQL Server Analysis Services 64 Bit Evaluation (x64) RTM 13.0.2000.8.

使用 PowerShell 來驗證檔案版本。Use PowerShell to verify file version.

您可以使用 PowerShell 來驗證產品版本。You can use PowerShell to verify the product version. 如果您想要編寫指令碼或自動化版本驗證,PowerShell 是個好選項。PowerShell is a good option if you want to script or automate version verification.

(get-childitem "C:\Program Files\Microsoft SQL Server\MSAS13.POWERPIVOT2000\OLAP\bin\msmdsrv.exe").VersionInfo  

上述 PowerShell 命令會傳回類似下列資訊:The above PowerShell command returns information similar to the following:

ProductVersion FileVersion FileNameProductVersion FileVersion FileName

13.0.2000.8 2016.0130.200 C:\Program Files\Microsoft SQL Server\MSAS13.POWERPIVOT2000\OLAP\bin\msmdsrv.exe13.0.2000.8 2016.0130.200 C:\Program Files\Microsoft SQL Server\MSAS13.POWERPIVOT2000\OLAP\bin\msmdsrv.exe

驗證 SharePoint 上的 MSOLAP 資料提供者版本Verify the MSOLAP Data Provider Version on SharePoint

使用下列指示即可查看 Excel Services 信任的 Analysis Services OLE DB 提供者版本。Use the following instructions to check which versions of the Analysis Services OLE DB providers are trusted by Excel Services. 您必須是伺服陣列或服務應用程式系統管理員,才能檢查 Excel Services 信任的資料提供者設定。You must be a farm or service application administrator to check the trusted data provider settings of Excel Services.

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

  2. 按一下 Excel Services 服務應用程式的名稱,例如 [ExcelServiceApp1]Click the name of the Excel Services service application, for example ExcelServiceApp1.

  3. 按一下 [信任的資料提供者]Click Trusted Data Providers. 您應該會看到 MSOLAP.5 (Microsoft OLE DB Provider for OLAP Services 11.0)。You should see MSOLAP.5 (Microsoft OLE DB Provider for OLAP Services 11.0). 如果您已升級 PowerPivot for SharePointPower Pivot for SharePoint 安裝,也會看到舊版的 MSOLAP.4。If you upgraded your PowerPivot for SharePointPower Pivot for SharePoint installation, you will also see MSOLAP.4 from the previous version.

  4. 如需詳細資訊,請參閱 加入 MSOLAP.5 做為 Excel Services 中受信任的資料提供者For more information, see Add MSOLAP.5 as a Trusted Data Provider in Excel Services.

MSOLAP.4 會描述為 Microsoft OLE DB Provider for OLAP Services 10.0。MSOLAP.4 is described as the Microsoft OLE DB Provider for OLAP Services 10.0. 這個版本可能是與 Excel Services 一併安裝的 SQL Server 2008SQL Server 2008 預設版本,或者是 SQL Server 2008 R2SQL Server 2008 R2 版本。This version might be the default version from SQL Server 2008SQL Server 2008 that is installed with Excel Services, or it might be the SQL Server 2008 R2SQL Server 2008 R2 version. SharePoint 安裝的預設版本不支援 Power PivotPower Pivot 資料存取。The default version that SharePoint installs does not support Power PivotPower Pivot data access. 您必須擁有 SQL Server 2008 R2SQL Server 2008 R2 版本或更新版本,才能連接 SharePoint 上的 Power PivotPower Pivot 活頁簿。You must have the SQL Server 2008 R2SQL Server 2008 R2 version or later to connect to Power PivotPower Pivot workbooks on SharePoint. 若要確認您擁有 SQL Server 2008 R2SQL Server 2008 R2 版本,請使用上一節中說明如何檢視檔案屬性以確認版本的指示。To verify you have the SQL Server 2008 R2SQL Server 2008 R2 version, use the instructions in the previous section that explain how to verify the version by viewing file properties.

驗證 ADOMD.NET 資料提供者版本Verify the ADOMD.NET Data Provider Version

使用下列指示來檢查所安裝的 ADOMD.NET 版本。Use the following instructions to check which version of ADOMD.NET is installed. 您必須是伺服陣列或服務應用程式系統管理員,才能檢查 Excel Services 信任的資料提供者設定。You must be a farm or service application administrator to check the trusted data provider settings of Excel Services.

  1. 在 SharePoint 應用程式伺服器上,瀏覽至 c:\Windows\AssemblyOn your SharePoint application server, browse to c:\Windows\Assembly.

  2. 依組件名稱排序,並搜尋 Microsoft.Analysis Services.Adomd.ClientSort by assembly name and find the Microsoft.Analysis Services.Adomd.Client.

  3. 確認您有 13.0.<組建編號> 版。Verify you have version 13.0.<build number>.

在 SharePoint 伺服器陣列中升級多部 Power Pivot for SharePoint 伺服器Upgrading Multiple Power Pivot for SharePoint Servers in a SharePoint Farm

在包含多部 PowerPivot for SharePointPower Pivot for SharePoint 伺服器的多重伺服器拓撲中,所有伺服器執行個體和元件都必須是相同版本。In a multi-server topology that includes more than one PowerPivot for SharePointPower Pivot for SharePoint server, all server instances and components must be the same version. 執行最新軟體版本的伺服器會設定伺服陣列中所有伺服器的層級。The server that runs the highest version of the software sets the level for all servers in the farm. 如果您只要升級部分伺服器,執行較舊版軟體的伺服器在升級之前將變成無法使用。If you upgrade just some of the servers, the ones that are running older versions of the software will become unavailable until they are also upgraded.

升級第一部伺服器之後,尚未升級的其他伺服器 將會變成無法使用After you upgrade the first server, additional servers that are not yet upgraded will become unavailable. 在所有伺服器執行相同層級之後,即可恢復使用。Availability is restored after all servers run at the same level.

SQL Server 安裝程式會就地升級實體電腦上的 Power PivotPower Pivot 方案檔,但若要升級伺服器陣列使用的方案,則必須使用本文上一節所述的 Power PivotPower Pivot 設定工具。SQL Server Setup upgrades the Power PivotPower Pivot solution files in place on the physical computer, but to upgrade the solutions in use by the farm, you must use the Power PivotPower Pivot Configuration Tool described in a previous section of this article..

將 QFE 套用至伺服器陣列中的 Power Pivot 執行個體Applying a QFE to a Power Pivot instance in the farm

修補 Power PivotPower Pivot for SharePoint 伺服器,會將現有的程式檔案更新成包含特定問題修正的較新版本。Patching a Power PivotPower Pivot for SharePoint server updates existing program files with a newer version that includes a fix for a specific problem. 將 QFE 套用至多重伺服器拓撲時,沒有您必須先開始的主要伺服器。When applying a QFE to a multi-server topology, there is no primary server that you must begin with. 只要您將相同的 QFE 套用至伺服器陣列中的其他 Power PivotPower Pivot 伺服器,就可以從任何伺服器開始。You can start with any server as long as you apply the same QFE to the other Power PivotPower Pivot servers in the farm.

套用 QFE 時,您也必須在伺服器陣列組態資料庫中執行更新伺服器版本資訊的組態設定。When you apply the QFE, you must also perform a configuration step that updates the server version information in the farm configuration database. 已修補之伺服器的版本會變成預期的伺服陣列新版本。The version of the patched server becomes the new expected version for the farm. 在所有電腦上套用並設定 QFE 之前,沒有 QFE 的 Power PivotPower Pivot for SharePoint 執行個體將無法用於處理 Power PivotPower Pivot 資料的要求。Until the QFE is applied and configured across all machines, the Power PivotPower Pivot for SharePoint instances that do not have the QFE will be unavailable to handle requests for Power PivotPower Pivot data.

為確保正確套用並設定 QFE,請遵循下列指示進行:To ensure the QFE is applied and configured correctly, follow these instructions:

  1. 使用隨附在 QFE 中的指示,安裝修補程式。Install the patch using the instructions that are provided with the QFE.

  2. 啟動 Power PivotPower Pivot 組態工具。Start the Power PivotPower Pivot Configuration Tool.

  3. 按一下 [升級功能、服務、應用程式和方案] ,然後按一下 [確定]Click Upgrade Features, Services, Applications and Solutions, and then click OK.

  4. 檢閱升級工作中所包含的動作,然後按一下 [驗證]Review the actions that are included in the upgrade task, and then click Validate.

  5. 按一下 [執行] 套用動作。Click Run to apply the actions.

  6. 針對伺服器陣列中的其他 Power PivotPower Pivot for SharePoint 執行個體,重複這個動作。Repeat for additional Power PivotPower Pivot for SharePoint instances in the farm.

    重要

    在多重伺服器部署中,請務必先修補並設定每個執行個體,然後再繼續進行下一部機器。In a multi-server deployment, be sure to both patch and configure each instance before continuing to the next machine. Power PivotPower Pivot 組態工具必須先完成目前執行個體的升級工作,才能移到下一個執行個體。The Power PivotPower Pivot Configuration Tool must complete the upgrade task for the current instance before you move on to the next instance.

若要檢查伺服器陣列中服務的版本資訊,請在管理中心中的 [升級與修補管理] 區段中,使用 [檢查產品與修補程式安裝狀態] 頁面。To check version information for services in the farm, use the Check product and patch installation status page in the Upgrade and Patch Management section in Central Administration.

升級後的驗證工作Post-upgrade verification tasks

升級完成後,使用下列步驟來驗證伺服器正常運作。After upgrade is complete, use the following steps to verify the server is operational.

工作Task 連結Link
確認伺服器在執行 Power PivotPower Pivot for SharePoint 的所有電腦上執行。Verify the service is running on all computers that run Power PivotPower Pivot for SharePoint. 啟動或停止 Power Pivot for SharePoint ServerStart or Stop a Power Pivot for SharePoint Server
確認網站集合層級的功能啟用。Verify feature activation at the site collection level. 在管理中心為網站集合啟用 Power Pivot 功能整合Activate Power Pivot Feature Integration for Site Collections in Central Administration
確認個別的 Power PivotPower Pivot 活頁簿會透過開啟活頁簿,並按一下篩選與交叉分析篩選器起始查詢來正確載入。Verify individual Power PivotPower Pivot workbooks are loading properly by opening a workbook and clicking on filters and slicers to initiate a query. 檢查快取的檔案是否存在硬碟上。Check for the presence of cached files on the hard drive. 快取的檔案可確認資料檔案已在實體伺服器上載入。A cached file confirms that the data file was loaded on that physical server. 尋找 c:\Program Files\Microsoft SQL Server\MSAS13.POWERPIVOT\OLAP\Backup 資料夾中的快取檔案。Look for cached files in the c:\Program Files\Microsoft SQL Server\MSAS13.POWERPIVOT\OLAP\Backup folder.
在設定為資料重新整理的所選活頁簿上測試資料重新整理。Test data refresh on selected workbooks that are configured for data refresh. 測試資料重新整理最簡單的方式就是修改資料重新整理排程,也就是選擇 [並且盡快重新整理] 核取方塊,讓資料重新整理立即執行。The easiest way to test data refresh is to modify a data refresh schedule, choosing the Also refresh as soon as possible checkbox so that data refresh runs immediately. 此步驟將判斷目前活頁簿的資料重新整理是否成功。This step will determine whether data refresh is successful for the current workbook. 針對其他常用的活頁簿重複這些步驟以確保資料重新整理運作正常。Repeat these steps for other frequently used workbooks to ensure that data refresh is functional. 如需排程資料重新整理的詳細資訊,請參閱 排程資料重新整理 (Power Pivot for SharePoint)For more information about scheduling data refresh, see Schedule a Data Refresh (Power Pivot for SharePoint).
一段時間之後,監視 Power PivotPower Pivot 管理儀表板中的資料重新整理報表,以確認沒有資料重新整理錯誤。Over time, monitor the data refresh reports in Power PivotPower Pivot Management Dashboard to confirm there are no data refresh errors. Power Pivot 管理儀表板和使用量資料Power Pivot Management Dashboard and Usage Data

如需如何設定 Power PivotPower Pivot 設定和功能的詳細資訊,請參閱 管理中心的 PowerPivot 伺服器管理和組態For more information about how to configure Power PivotPower Pivot settings and features, see Power Pivot Server Administration and Configuration in Central Administration.

如需引導您完成所有安裝後組態工作的逐步指示,請參閱 初始組態 (Power Pivot for SharePoint)For step-by-step instructions that guide you through all of the post-installation configuration tasks, see Initial Configuration (Power Pivot for SharePoint).

另請參閱See Also

SQL Server 2016 的版本及支援功能 Editions and Supported Features for SQL Server 2016
PowerPivot for SharePoint 2010 安裝Power Pivot for SharePoint 2010 Installation