Five Golden Rules for Cleaning Data in Power BI

Swaathi Sundaramurugan
10 min readMay 25, 2022

--

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

--

--

Swaathi Sundaramurugan

Data Engineer Intern | Graduate Student at Simon Fraser University | Full Stack Developer | Writer