直接在 Power BI Desktop 中输入数据Enter data directly into Power BI Desktop

使用 Power BI Desktop,你可以直接输入数据并在报表和可视化效果中使用该数据。With Power BI Desktop, you can enter data directly and use that data in your reports and visualizations. 例如,可以复制部分工作簿或网页,然后将其粘贴到 Power BI Desktop。For example, you can copy portions of a workbook or web page, then paste it into Power BI Desktop.

若要直接输入数据,请从“开始”功能区选择“输入数据”。To enter data directly, select Enter Data from the Home ribbon.

如果适当,Power BI Desktop 可能会尝试对数据进行次要转换,如同当你从任何源加载数据时一样。Power BI Desktop may attempt to make minor transformations on the data, if appropriate, just like it does when you load data from any source. 例如,在以下情况下它会将数据的第一行提升至标头。For example, in the following case it promoted the first row of data to headers.

如果想要调整你输入(或粘贴)的数据,可以选择“编辑”按钮以打开“查询编辑器”,在其中你可以在将数据引入 Power BI Desktop 前调整和转换数据。If you want to shape the data you entered (or pasted), you can select the Edit button to bring up Query Editor, where you can shape and transform the data before bringing it into Power BI Desktop. 也可以选择“加载”按钮导入数据,如图所示。Or you can select the Load button to import the data as it appears.

当你选择“加载”时,Power BI Desktop 将根据你的数据创建新表,并使其在“字段”窗格可用。When you select Load, Power BI Desktop creates a new table from your data, and makes it available in the Fields pane. 下图中,Power BI Desktop 显示了我的新表,默认名称为 Table1,以及在该表中创建的两个字段。In the following image, Power BI Desktop shows my new table, called Table1 by default, and the two fields within that table that were created.

就是这么简单 – 将数据输入到 Power BI Desktop 就是这么简单。And that’s it – it’s that easy to enter data into Power BI Desktop.

你现在已准备好在 Power BI Desktop 中使用数据来创建视觉对象、报表或与你可能想要连接和导入的其他数据(如 Excel 工作簿、数据库或任何其他数据源)进行交互。You’re now ready to use the data in Power BI Desktop to create visuals, reports, or interact with any other data you might want to connect with and import, such as 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: