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.

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 to 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: 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.

How to Enter Data into Power BI 6

Please wait until the Load is 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 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.

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 into the Create table window (Control + C and Control + V). Remember, it 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 into 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 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.

How to Enter Data into Power BI 18

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.

How to Enter Data into Power BI 19

About Suresh

Suresh is the founder of TutorialGateway and a freelance software developer. He specialized in Designing and Developing Windows and Web applications. The experience he gained in Programming and BI integration, and reporting tools translates into this blog. You can find him on Facebook or Twitter.

Comments are closed.