Enter Data into Power BI Desktop

In this Power BI Tutorial, We will explore Power BI Enter Data option, Why and how we can use this Enter Data in Power BI.

Also, We will see how to enter data from excel file to Power BI desktop and enter data from a Text file to Power BI desktop.

If you are new to Microsoft Power BI, then using this below article, you can learn the Power BI from the beginning: Getting started with Microsoft Power BI Tool

Enter Data into Power BI Desktop

Enter data option helps you to enter any table data or copying data from the text file/excel file to your Power BI work environment.

Learn how to export Power BI reports to excel and steps to export Power BI reports to PDF.

Suppose, In your Organization, You have some files like text or excel and you want to display those files in the Power BI Desktop. In this case, you cannot enter those table data manually. For this purpose only, Power BI provides an option which is known as Enter Data.

How to Enter Data into Power BI Desktop?

Here I will explain to you how you can enter Data in the Power BI desktop. To enter the new data in the Power BI Desktop, Click on the Enter Data option which is present under the Home tab as shown below.

enter data into power bi
enter data into power bi

Once you will click on the Enter Data option from the Home tab, it will open a new window known as Create Table. In this window, you can create new rows and new columns as per your requirement.

enter data in power bi
enter data in power bi

Here in this below window, you can change or modify the column header by double-clicking on it. I have changed the column name from Column1 to Bill no. as like the below screenshot.

Similarly, To add any new rows and columns, just click on the * symbol. You can add multiple numbers of rows and columns by clicking on the * symbol as shown below.

power bi enter data
power bi enter data

When you will click on * symbol, the new column or new row name will display as Column1 or Row1. As per your requirement, you can rename your column or row name.

Enter data into power bi desktop
power bi desktop enter data

In this example, I have added some columns, rows and some data into the Table window in Power BI desktop. Also, you can rename the table name which is present at the bottom of the window where I have changed it to Sales Revenue.

While all things will over, you can click on the Load button to load this table into Power Bi desktop. Similarly, If you want to edit this table data, then you can click on the Edit option.

how to enter data into power bi
enter data into power bi desktop

Wait a while until the load is completed as shown below.

Enter data directly into Power BI desktop
enter data into power bi dashboard

Once the load is completed successfully, you can see your new table in the Fields section in Power BI Desktop. As here I have created a new table named as Sales Revenue, so it is displaying in the Fields section as below screenshot.

enter data to power bi desktop
how to enter data into power bi

Enter data from Excel file to power bi desktop

Suppose, you have some data in the Excel file and you want to display those data in the Power BI, then you can use this Enter Data option. Follow the below processes to view the Excel data in the Power BI Desktop.

Click on the Enter Data option under the File tab and the new table window will open as shown below.

Enter data from excel file to power bi desktop
Enter data from excel file to power bi desktop

Now go to your specific Excel file and copy all the data from excel. (You can copy the data by using Ctrl + c)

Enter data from excel file into power bi desktop
Enter data from excel file into power bi desktop

Paste it in the Create Table window by using Ctrl + v. All the column headers will display automatically in the Power BI Desktop. Just rename the Table name (if you want then only) and then click on to the Load button.

how to enter data from excel file to power bi desktop
how to enter data from excel file to power bi desktop

Wait a while until the load is completed as shown below.

enter data power bi
how to enter data into power bi dashboard

Once the load is completed successfully, you can see your new table in the Fields section in Power BI Desktop. As here I have created a new table named Sales Report, so it is displaying in the Fields section like the below screenshot.

how to enter data into power bi desktop
how to enter data into power bi desktop

Suppose you want to enter the data from a Text file to Power BI Desktop, then in the same way you can load the data.

In the same process, you can create a Table window using the Enter Data option. Then go to your Text file and copy (Ctrl +c)all the data from the file and paste (Ctrl + v) it into the Power BI Create table window.

Once the new table load is successfully completed, you can view your new table in the Fields section in the Power BI Desktop.

You may also like the below Power BI tutorials:

Hence in this Power BI Tutorial, We discussed what is Power BI Enter Data option, Why and how we can use this Enter Data in Power BI.

Also, We saw how we can enter data from excel file to Power BI desktop and enter data from a Text file to Power BI desktop.

>