重新整理建立自本機磁碟上 Power BI Desktop 檔案的資料集Refresh a dataset created from a Power BI Desktop file on a local drive

支援的項目有哪些?What’s supported?

在 Power BI 中,從 Power BI Desktop 檔案建立的資料集支援 [立即重新整理] 和 [排程重新整理],這些檔案是從本機磁碟匯入,本機磁碟使用 [取得資料]/查詢編輯器連接下列任何資料來源並載入資料︰In Power BI, Refresh Now and Schedule Refresh is supported for datasets created from Power BI Desktop files imported from a local drive where Get Data/Query Editor is used to connect to and load data from any of the following data sources:

Power BI Gateway - PersonalPower BI Gateway - Personal

  • Power BI Desktop 的 [取得資料] 和查詢編輯器都會顯示所有的線上資料來源。All online data sources shown in Power BI Desktop’s Get Data and Query Editor.
  • Power BI Desktop 的 [取得資料] 和查詢編輯器都會顯示所有的內部部署資料來源,但 Hadoop 檔案 (HDFS) 與 Microsoft Exchange 除外。All on-premises data sources shown in Power BI Desktop’s Get Data and Query Editor except for Hadoop file (HDFS) and Microsoft Exchange.

內部部署資料閘道On-premises data gateway

資料來源Data source
Analysis Services 表格式Analysis Services Tabular
Analysis Services 多維度Analysis Services Multidimensional
SQL ServerSQL Server
SAP HANASAP HANA
OracleOracle
TeradataTeradata
檔案File
資料夾Folder
SharePoint 清單 (內部部署)SharePoint list (on-premises)
WebWeb
ODataOData
IBM DB2IBM DB2
MySQLMySQL
SybaseSybase
SAP BWSAP BW
IBM Informix 資料庫IBM Informix Database
ODBCODBC

注意

必須安裝並執行閘道器,才能讓 Power BI 連接至內部部署資料來源並重新整理資料集。A gateway must be installed and running in order for Power BI to connect to on-premises data sources and refresh the dataset.

您可以選取 [主資料夾] 功能區的 [重新整理],直接在 Power BI Desktop 手動執行一次性的重新整理。You can perform a one-time, manual refresh right in Power BI Desktop by selecting Refresh on the Home ribbon. 當您在這裡選取 [重新整理] 時,就會使用原始資料來源的更新資料重新整理檔案模型中的資料。When you select Refresh here, the data in the file’s model is refreshed with updated data from the original data source. 這類的重新整理,完全位於 Power BI Desktop 應用程式本身,不同於 Power BI 中的手動或排程重新整理,所以請務必了解此差異。This kind of refresh, entirely from within the Power BI Desktop application itself, is different from manual or scheduled refresh in Power BI, and it’s important to understand the distinction.

當您從本機磁碟機匯入 Power BI Desktop 檔案時,模型的資料和其他相關資訊都會載入 Power BI 服務的資料集內。When you import your Power BI Desktop file from a local drive, data, along with other information about the model is loaded into a dataset in the Power BI service. 在 Power BI 服務 (而非 Power BI Desktop) 中,因為 Power BI 服務中的報表是以該資料集為基礎,所以您會想要重新整理該資料集的資料。In the Power BI service, not Power BI Desktop, you want to refresh data in the dataset because that is what your reports, in the Power BI service, are based on. 因為資料來源位於外部,所以您可以使用 [立即重新整理] 手動重新整理資料集,或您可以使用 [排程重新整理] 設定重新整理排程。Because the data sources are external, you can manually refresh the dataset by using Refresh now or you can setup a refresh schedule by using Schedule Refresh.

當您重新整理資料集時,Power BI 不會連接到本機磁碟機上的檔案來查詢更新資料。When you refresh the dataset, Power BI does not connect to the file on the local drive to query for updated data. 它會使用在資料集的資訊,直接連接到資料來源,以查詢更新資料,然後載入資料集。It uses information in the dataset to connect directly to the data sources to query for updated data it then loads into the dataset.

注意

此資料集內重新整理的資料不會同步回到本機磁碟機上的檔案。Refreshed data in the dataset is not synchronized back to the file on the local drive.

我要如何排程重新整理?How do I schedule refresh?

當您設定重新整理排程時,Power BI 會直接連接到資料來源,方法是使用資料集內的連接資訊和認證來查詢更新資料,然後將更新資料載入資料集。When you setup a refresh schedule, Power BI will connect directly to the data sources using connection information and credentials in the dataset to query for updated data, then load the updated data into the dataset. 此外,也會更新任何在 Power BI 服務中該資料集上的報表和儀表板視覺效果。Any visualizations in reports and dashboards based on that dataset in the Power BI service are also updated.

如需如何設定排程重新整理的詳細資訊,請參閱設定排程重新整理For details on how to setup schedule refresh, see Configure Schedule Refresh.

發生錯誤時When things go wrong

如果發生錯誤,問題通常起因於 Power BI 無法登入資料來源,或資料集連接至內部部署資料來源時,閘道器離線。When things go wrong, it’s usually because Power BI can’t sign into data sources, or if the dataset connects to an on-premises data source, the gateway is offline. 請確認 Power BI 可以登入資料來源。Make sure Power BI can sign into data sources. 如果您用以登入資料來源的密碼已變更,或 Power BI 從資料來源登出,請務必嘗試在 [資料來源認證] 中再次登入您的資料來源。If a password you use to sign into a data source changes, or Power BI gets signed out from a data source, be sure to try signing into your data sources again in Data Source Credentials.

請務必核取 [傳送重新整理失敗通知電子郵件給我] 。Be sure to leave the Send refresh failure notification email to me checked. 您會想要立刻知道排定的重新整理是否失敗。You’ll want to know right away if a scheduled refresh fails.

疑難排解Troubleshooting

有時候重新整理資料可能不會如預期執行。Sometimes refreshing data may not go as expected. 這通常是閘道連線問題之故。Typically this will be an issue connected with a gateway. 請參閱閘道疑難排解文章,以取得工具和已知的問題。Take a look at the gateway troubleshooting articles for tools and known issues.

為內部部署資料閘道進行疑難排解Troubleshooting the on-premises data gateway

對 Power BI Gateway - Personal 進行疑難排解Troubleshooting the Power BI Gateway - Personal

有其他問題嗎?More questions? 嘗試在 Power BI 社群提問Try asking the Power BI Community