Manual data entry

PowerBI Desktop allows you to obtain data from different sources. They are being acquired into tables between which we later create relationships to create the Data Model. Sometimes it is necessary to have temporary table that needs to be used to create a specific report. To create such a table and manually fill it, you can use the Enter Data option.

The Enter Data option is activated from the PowerBI Desktop application Home ribbon. Once it is launched, a window will open that allows you to enter data in a similar way you would do it in Excel. Also, in the text box, just right of the Name label, you can name it immediately. Clicking on the Load button ends the process of creating a table, and by clicking Cancel you quit the performed operation.

Before you import a table, I advise you to click on the Edit button. In this way you’ll enter the Query Editor where you can perform several more important operations over the data before they can be used for analysis. First, you need to define that the first row of the table is its header. And then, it would be good to specify data types clearly so that the columns of the tables can be used in different calculations.