使用自動的資料重新整理帳戶 (SharePoint Server 2013) 來設定 Power Pivot 的排定的資料重新整理Configure scheduled data refresh for Power Pivot by using the unattended data refresh account (SharePoint Server 2013)

摘要:了解如何在 Power Pivot 中設定排定的資料重新整理 sharepoint 使用自動的資料重新整理帳戶。Summary: Learn to configure scheduled data refresh in Power Pivot for SharePoint by using the unattended data refresh account.

重要

此案例僅適用於 SharePoint Server 2013。This scenario applies only to SharePoint Server 2013.

在本文中,我們將看看一下使用自動的資料重新整理帳戶在 SQL Server 2012 Power Pivot for SharePoint 2013 中設定排定的資料重新整理。In this article, we'll take a look at configuring scheduled data refresh in SQL Server 2012 Power Pivot for SharePoint 2013 by using the unattended data refresh account.

藉由使用自動資料重新整理帳戶,您可以使用管理員設定的帳戶來重新整理活頁簿的資料。By using the unattended data refresh account, you can have the data in your workbooks refreshed using an account that was configured by your administrator.

開始之前Before you begin

開始之前,您需要有:Before starting, you will need:

此外,請確定Excel Services為 SharePoint Server 2013 伺服器陣列中設定。Additionally, be sure that Excel Services is configured in your SharePoint Server 2013 farm.

影片示範Video demonstration

這段影片會顯示在 SQL Server 2012 Power Pivot for SharePoint 2013 中設定排定的資料重新整理使用自動的資料重新整理帳戶,如本文所述的步驟。This video shows the steps involved in configuring scheduled data refresh in SQL Server 2012 Power Pivot for SharePoint 2013 by using the unattended data refresh account, as described in this article.

影片: 使用自動的資料重新整理帳戶來設定 Power Pivot 的排定的資料重新整理Video: Configure scheduled data refresh for Power Pivot by using the unattended data refresh account

使用自動的資料重新整理帳戶來設定排定的資料重新整理第一個步驟是以確定它必須在報表中所使用的資料來源的適當的存取權。我們將看看一下 SQL Server 和 Analysis Services 資料來源。The first step in setting up scheduled data refresh by using the unattended data refresh account is to ensure that it has the proper access to the data source used in your report. We'll take a look at SQL Server and Analysis Services data sources.

使用 SQL Server 資料來源Use a SQL Server data source

如果您使用 SQL Server 資料來源,您需要確定自動的資料重新整理帳戶具有讀取 SQL Server 資料庫的權限您資料所在。If you're using SQL Server for your data source, you'll need to make sure that your unattended data refresh account has read permissions to the SQL Server database where your data resides.

若要設定的讀取權限的 SQL Server 資料庫To set read permission on a SQL Server database

  1. 在 SQL Server Management Studio 中,連線至資料庫引擎。In SQL Server Management Studio, connect to the database engine.

  2. 展開 [安全性]。Expand Security.

  3. 登入,以滑鼠右鍵按一下,然後選擇 [新增登入Right-click Logins, and then choose New Login.

  4. 在 [登入名稱] 方塊中輸入您的自動的資料重新整理帳戶的網域和使用者名稱。In the Login name box, type the domain and user name of your unattended data refresh account.

  5. 在 [使用者對應] 頁面上,選取您要授與存取權之資料庫的 [對應] 核取方塊。On the User Mapping page, select the Map check box for the database to which you want to grant access.

  6. 選取 [ db_datareader]核取方塊。Select the db_datareader check box.

  7. 選擇 [確定]。Choose OK.

如果您也使用 Analysis Services,請參閱 [下一步] 區段中的如何設定 Analysis Services 資料來源權限的相關資訊。如果您不使用 Analysis Services,略過預先設定Power Pivot for SharePoint 中的資料重新整理排程If you're also using Analysis Services, see the next section for information about how to set up access to Analysis Services data sources. If you're not using Analysis Services, skip ahead to Set up a data refresh schedule in Power Pivot for SharePoint.

使用 Analysis Services 資料來源Use an Analysis Services data source

如果您使用的 Analysis Services,您需要確定您的資料存取帳戶是適當的 Analysis Services 角色的成員與該角色具有 Analysis Services cube 的讀取權限。If you're using Analysis Services, you'll need to make sure that your data access account is a member of the proper Analysis Services role and that the role has read access to the Analysis Services cube.

若要設定的讀取權限 Analysis Services cubeTo set read permission on an Analysis Services cube

  1. 在 SQL Server Management Studio,連線至 Analysis Services。In SQL Server Management Studio, connect to Analysis Services.

  2. 依序展開 [資料庫],並展開您要授與存取權的資料庫。Expand Databases, and expand the database to which you want to grant access.

  3. 以滑鼠右鍵按一下 [角色],然後選擇 [新增角色Right-click Roles, and then choose New Role.

  4. 輸入角色的名稱。Type a name for the role.

  5. 在 [成員資格] 頁面上:On the Membership page:

  6. 選擇 [新增]。Choose Add.

  7. 輸入您的自動的資料重新整理帳戶,然後選擇[確定]Type your unattended data refresh account, and then choose OK.

  8. 在 [ Cube ] 頁面上,選取您要授與存取權之 cube 的讀取權限。On the Cubes page, select Read access for the cubes to which you want to grant access.

  9. 選擇 [確定]。Choose OK.

設定資料重新整理排程在 Power Pivot for SharePointSet up a data refresh schedule in Power Pivot for SharePoint

每個項目設定之後,我們可以設定重新整理排程和中 Power Pivot for SharePoint 的其他設定。我們將啟動建置含有在 Excel 中的資料模型的測試活頁簿並將其發佈至其中啟用 Power Pivot for SharePoint 網站集合中的文件庫。然後,我們可以設定重新整理排程。Now that everything is configured, we can set up the refresh schedule and other settings in Power Pivot for SharePoint. We'll start by building a test workbook with a data model in Excel and publishing it to a document library in a site collection where Power Pivot for SharePoint is enabled. Then, we can set the refresh schedule.

建立測試活頁簿To create a test workbook

  1. 在 Excel 中,在 [資料] 索引標籤上選擇 [從其他來源],然後按從 SQL ServerIn Excel, on the Data tab, choose From Other Sources, and then choose From SQL Server.

  2. 輸入您資料所在的 SQL Server 執行個體的名稱。Type the name of the instance of SQL Server where your data resides.

  3. 遵循精靈的指示,連線至包含您資料的表格。Follow the wizard through to connect to the table that contains your data.

  4. 精靈完成時,您應該會看到 [匯入資料] 對話方塊。選擇 [只建立連線] 選項,然後選取 [新增此資料至資料模型] 核取方塊。When the wizard completes, you should see the Import Data dialog box. Choose the Only Create Connection option, and then select the Add this data to the Data Model check box.

  5. 選擇 [確定]。Choose OK.

  6. 在 [ Power Pivot ] 索引標籤上選擇 [管理]。On the Power Pivot tab, choose Manage.

  7. Power Pivot ] 功能區中,選擇 [樞紐分析表On the Power Pivot ribbon, choose PivotTable.

  8. 在 [插入樞紐] 對話方塊中,選擇 [現有工作表] 選項,然後選擇[確定]On the Insert Pivot dialog box, choose the Existing Worksheet option, and then choose OK.

  9. 選取樞紐分析表報表要有的欄位。Select the fields that you want in the PivotTable report.

  10. 儲存至文件庫的活頁簿上已啟用 Power Pivot 的網站集合。Save the workbook to a document library on the site collection where you enabled Power Pivot.

活頁簿有已儲存至 SharePoint 文件庫,現在讓我們設定重新整理設定。Now that the workbook has been saved to a SharePoint document library, let's configure the refresh settings.

若要設定的活頁簿的重新整理設定To configure refresh settings for a workbook

  1. 在 Excel 活頁簿儲存所在的文件庫,選擇省略符號 (...) 控制項兩次,,然後選擇 [管理 Power Pivot 資料重新整理In the document library where your Excel workbook is stored, choose the ellipsis (...) control twice, and then choose Manage Power Pivot Data Refresh.

    文件庫控制項的螢幕擷取畫面。

  2. 在 [管理資料重新整理] 頁面上選取 [啟用] 核取方塊。On the Manage Data Refresh page, select the Enable check box.

  3. 在 [排程詳細資料] 區段中,選擇想用於重新整理此活頁簿中的資料的排程選項。In the Schedule Details section, choose the schedule options that you want for refreshing the data in this workbook.

  4. (選用) 若要立即重新整理活頁簿,請選取 [盡也重新整理] 核取方塊。Optionally, if you want the workbook to refresh right away, select the Also refresh as soon as possible check box.

  5. 在 [認證] 區段中選擇 [使用的資料重新整理設定由系統管理員帳戶] 選項。In the Credentials section, choose the Use the data refresh account configured by the administrator option.

  6. 選擇 [確定]。Choose OK.

您可以測試如果資料重新整理可以透過一些變更您的資料,並再使用也重新整理盡選項立即重新整理活頁簿運作正常。You can test if data refresh is working properly by making some changes to your data, and then setting the workbook to refresh right away by using the Also refresh as soon as possible option.

另請參閱See also

概念Concepts

設定 Power Pivot for SharePoint 2013Configure Power Pivot for SharePoint 2013

使用指定的帳戶 (SharePoint Server 2013) 來設定 Power Pivot 的排定的資料重新整理Configure scheduled data refresh for Power Pivot by using a specified account (SharePoint Server 2013)

使用自動的資料重新整理帳戶 (SharePoint Server 2013) 來設定 Power Pivot 的排定的資料重新整理Configure scheduled data refresh for Power Pivot by using the unattended data refresh account (SharePoint Server 2013)