在 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 会在 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: