Five Golden Rules for Cleaning Data in Power BI

After getting data into Power BI from different sources, it is better to transform the dataset before loading it into the Power BI since it improves queries’ performance and saves the internal memory space of Power BI.

Here are five Golden rules for cleaning data efficiently in Power BI:

Data Cleaning Flowchart (Image from The Big Data Club)

Dealing with Column headers

The first step of any cleaning process is to decide and indicate the columns that will be used in the data analysis as per the requirement.

Five steps to clean Column Headers (Image from The Big Data Club)

Promote Headers and Remove Top Rows

It is not mandatory for every data source to have the right column names as their column headers. The column headers can be located in the first row of the dataset. Sometimes, they can be found after several empty rows. Hence, the first step is to make the right row the column headers. It can be done using the option Use First Row as Headers.

Use First Row as Headers option makes the first row of the table the column headers.

When there are empty rows in the dataset before the column names row. Remove those rows manually…