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.

How to Enter Data into Power BI 1

Clicking Enter Data option opens a new window called Create Table. Here, you can create new columns and add new rows.

How to Enter Data into Power BI 2

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.

How to Enter Data into Power BI 3

Now you can see the New column in Power BI.

How to Enter Data into Power BI 4

For the demonstration purpose, let me add a few rows

How to Enter Data into Power BI 5

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.

How to Enter Data into Power BI 6

Please wait until the Load completed.

How to Enter Data into Power BI 7

Now you can see the New table

How to Enter Data into Power BI 8

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

How to Enter Data into Power BI 9

Let me copy the data present in the Excel file

How to Enter Data into Power BI 10

And paste it in the Create table window (Control + C and Control + V). Remember, Power BI automatically detects the column headers.

How to Enter Data into Power BI 11

Let me rename the table as ExcelEmployee and click the Load button

How to Enter Data into Power BI 12

Now you can see the table

How to Enter Data into Power BI 13

Enter data from SQL table to Power BI Desktop

First, let me copy the data present in the SQL table

How to Enter Data into Power BI 14

and paste it in the create table window

How to Enter Data into Power BI 15

Please rename the table name as per your requirement, and hit the Load button

How to Enter Data into Power BI 16

Now you can see the table

How to Enter Data into Power BI 17

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.

How to Enter Data into Power BI 18

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.

How to Enter Data into Power BI 19

Comments are closed.