直接將資料輸入 Power BI DesktopEnter 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: