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.

Removing duplicates

When retreiving data from another application or their mass input, especially when done by more people, occurrence of repeated values is a common thing. If it’s a small amount of data, we’ll probably be able to manually remove them. However, when reviewing large tables, we can also use the Excel option that allows you to find and remove duplicates based on one or more criteria.