Skip to main content

Let me show you how to enter data in Power BI Desktop with an example. In real time, you may face a situation like manually entering table data or copying data from text file to your Power Bi working environment. In these situations, you can use the Power BI data entry option.

How to enter data in Power BI

To enter new data in Power BI Desktop, click Introduce data option under the Home tongue.

how-to-enter-data-into-power-bi-1-1613448

Clicking Introduce data The 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-8341439

Clicking in the Column1 area allows you to add a new name. Let me change the header of Column 1 as the Name. Then click * to add a new column.

how-to-enter-data-into-power-bi-3-7770602

You can now see the New column in Power BI.

how-to-enter-data-into-power-bi-4-3897579

For demo purposes let me add some rows

how-to-enter-data-into-power-bi-5-7370927

Use the text box next to the name: archived to rename the table. As you can see in the screenshot below, we rename the table as Example 1.

Then click the Upload button to upload this table to the Power Bi desktop. You can also click the Edit button to edit these fields.

how-to-enter-data-into-power-bi-6-4149551

Please wait until the upload is complete.

how-to-enter-data-into-power-bi-7-2946588

Now you can see the new table

how-to-enter-data-into-power-bi-8-3344863

Enter data from the Excel file into Power BI Desktop

In this example, we explain the steps to paste the data from the Excel file into Power BI Desktop. First, let me open the Create table window by clicking on the Introduce data button

how-to-enter-data-into-power-bi-9-1906996

Let me copy the data present in the excel file

how-to-enter-data-into-power-bi-10-7289554

And paste it into the Create Table window (Control + C and Control + V). Remember, Power BI automatically detects column headings.

how-to-enter-data-into-power-bi-11-3797213

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

how-to-enter-data-into-power-bi-12-6309678

Now you can see the table

how-to-enter-data-into-power-bi-13-7049393

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-2795758

and paste it in the table creation window

how-to-enter-data-into-power-bi-15-3197426

Rename the table as per your requirements and hit the Load button

how-to-enter-data-into-power-bi-16-3159806

Now you can see the table

how-to-enter-data-into-power-bi-17-2007242

Enter data from the text file into Power BI Desktop

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

how-to-enter-data-into-power-bi-18-6349987

Next, we paste it into the table creation window. You can see in the screenshot below, all the information stored in one column.

We can edit them by pressing the Edit button, but we will write a separate article to explain those techniques. So for now, we rename the table and load it to the desktop.

how-to-enter-data-into-power-bi-19-3915875

Let me show you how to enter data in Power BI Desktop with an example. In real time, you may face a situation like manually entering table data or copying data from text file to your Power Bi working environment. In these situations, you can use the Power BI data entry option.

How to enter data in Power BI

To enter new data in Power BI Desktop, click Introduce data option under the Home tongue.

how-to-enter-data-into-power-bi-1-1613448

Clicking Introduce data The 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-8341439

Clicking in the Column1 area allows you to add a new name. Let me change the header of Column 1 as the Name. Then click * to add a new column.

how-to-enter-data-into-power-bi-3-7770602

You can now see the New column in Power BI.

how-to-enter-data-into-power-bi-4-3897579

For demo purposes let me add some rows

how-to-enter-data-into-power-bi-5-7370927

Use the text box next to the name: archived to rename the table. As you can see in the screenshot below, we rename the table as Example 1.

Then click the Upload button to upload this table to the Power Bi desktop. You can also click the Edit button to edit these fields.

how-to-enter-data-into-power-bi-6-4149551

Please wait until the upload is complete.

how-to-enter-data-into-power-bi-7-2946588

Now you can see the new table

how-to-enter-data-into-power-bi-8-3344863

Enter data from the Excel file into Power BI Desktop

In this example, we explain the steps to paste the data from the Excel file into Power BI Desktop. First, let me open the Create table window by clicking on the Introduce data button

how-to-enter-data-into-power-bi-9-1906996

Let me copy the data present in the excel file

how-to-enter-data-into-power-bi-10-7289554

And paste it into the Create Table window (Control + C and Control + V). Remember, Power BI automatically detects column headings.

how-to-enter-data-into-power-bi-11-3797213

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

how-to-enter-data-into-power-bi-12-6309678

Now you can see the table

how-to-enter-data-into-power-bi-13-7049393

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-2795758

and paste it in the table creation window

how-to-enter-data-into-power-bi-15-3197426

Rename the table as per your requirements and hit the Load button

how-to-enter-data-into-power-bi-16-8776303

Now you can see the table

how-to-enter-data-into-power-bi-17-6484005

Enter data from the text file into Power BI Desktop

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

how-to-enter-data-into-power-bi-18-7008508

Next, we paste it into the table creation window. You can see in the screenshot below, all the information stored in one column.

We can edit them by pressing the Edit button, but we will write a separate article to explain those techniques. So for now, we rename the table and load it to the desktop.

how-to-enter-data-into-power-bi-19-8521144
R Marketing Digital