Let me show you how to Enter Data into Power BI Desktop with an example. In real-time, you might face a situation like manually entering table data, or copying data from the text file to your power bi work environment. In these situations, you can use Power BI enter data option.
How to Enter Data into Power BI
To enter new data into the Power BI Desktop, please click Enter Data option under the Home tab.
Clicking Enter Data option opens a new window called Create Table. Here, you can create new columns and add new rows.
By clicking the Column1 area, allow you to add a new name. Let me change the Column 1 header as the Name. Next, click on the * to add a new column.
Now you can see the New column in Power BI.
For the demonstration purpose, let me add a few rows
Use the Textbox beside the Name: filed to change the Table name. As you can see from the screenshot below, we changed the table name as Example 1.
Next, click on the Load button to load this table into Power Bi desktop. You can also click the Edit button to edit these fields.
Please wait until the Load completed.
Now you can see the New table
Enter data from Excel file to Power BI Desktop
In this example, we explain the steps to paste the data from Excel file to Power BI desktop. First, let me open the Create Table window by clicking the Enter data button
Let me copy the data present in the Excel file
And paste it in the Create table window (Control + C and Control + V). Remember, Power BI automatically detects the column headers.
Let me rename the table as ExcelEmployee and click the Load button
Now you can see the table
Enter data from SQL table to Power BI Desktop
First, let me copy the data present in the SQL table
and paste it in the create table window
Please rename the table name as per your requirement, and hit the Load button
Now you can see the table
Enter data from Text file to Power BI Desktop
First, let me open the text file. As you can see, the file not formatted properly. Let me copy the content in this text file.
Next, we pasted it in the create table window. You can see from the screenshot below, all the information stored in one column.
We can edit them by hitting the Edit button, but we will write a separate article to explain those techniques. Therefore, for now, we renamed the table name and loaded the table into the desktop.
