在 Power BI Desktop 中連接至 ExcelConnect to Excel in Power BI Desktop

從 Power BI Desktop 連接至 Excel 活頁簿很容易,本文將逐步引導您執行這些步驟。Connecting to an Excel workbook from Power BI Desktop is straightforward, and this article walks you through the steps.

在 Power BI Desktop 中,從 [主資料夾] 功能區選取 [取得資料] > [Excel]。In Power BI Desktop, select Get Data > Excel from the Home ribbon.

從出現的 [開啟] 對話方塊中選取您的活頁簿。Select your workbook from the Open dialog that appears.

Power BI Desktop 會顯示 [導覽] 視窗中活頁簿其他資料元素上的資料表。Power BI Desktop presents the tables on other data elements from the workbook in the Navigator window. 當您在左窗格中選取資料表時,資料的預覽會出現在右窗格中。When you select a table in the left pane, a preview of the data appears in the right pane.

您可以選取 [載入] 按鈕以匯入資料,或著如果您想要在將其送回 Power BI Desktop 之前使用 [查詢編輯器] 編輯資料,請選取 [編輯] 按鈕。You can select the Load button to import the data, or if you want to edit the data using Query Editor before bringing it into Power BI Desktop, select the Edit button.

當您載入資料時,Power BI Desktop 會顯示 [載入] 視窗,並顯示與載入資料相關聯的活動。When you load the data, Power BI Desktop displays the Load window and displays the activity associated with loading the data.

完成時,Power BI Desktop 會顯示 [欄位] 窗格中從 Excel 活頁簿匯入的資料表和欄位,就在桌面的右側。When complete, Power BI Desktop displays the tables and fields it imported from your Excel workbook in the Fields pane, on the right side of the Desktop.

這樣就大功告成了!And that’s it!

您現在可以在 Power BI Desktop 中使用從 Excel 活頁簿匯入的資料來建立視覺效果、報表,或與其他任何您可能想要連接或匯入的資料進行互動,例如其他 Excel 活頁簿、資料庫其他資料來源。You’re now ready to use the imported data from your Excel workbook in Power BI Desktop to create visuals, reports, or interact with any other data you might want to connect with and import, such as other Excel workbooks, databases, or any other data source.

後續步驟Next steps

您可以使用 Power BI Desktop 連接至各式各樣的資料。There are all sorts of data you can connect to using Power BI Desktop. 如需有關資料來源的詳細資訊,請參閱下列資源︰For more information on data sources, check out the following resources: