How to Enter Data into Power BI

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.

Click the Marked one.

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 to 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: field to change the Table name. As you can see from the screenshot below, we changed the table name to Example 1.

Next, click the Load button to load this table into the Power Bi desktop. You can also click the Edit button to edit these fields.

Please wait until the Load is completed.

Now you can see the New table

Enter data from the Excel file to Power BI Desktop

In this example, we explain the steps to paste the data from the Excel file to the 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 into the Create table window (Control + C and Control + V). Remember, it 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 into 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 a Text file to Power BI Desktop

First, let me open the text file. As you can see, the file is not formatted properly. Let me copy the content in this text file.

Next, we pasted it into the create table window. You can see from the screenshot below all the information is 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.