Get startedGet started for free

Transform before load

Raw data usually doesn't arrive in the perfect form when you account for human errors, bugs, and file conversion. Power BI accounts for this with the Power Query Editor, which allows you to transform data before loading it. In this exercise, you will load another dimension called DimCustomer, except unlike the others, this file will need to be edited prior to loading.

If you lost progress, close any open reports and load 2_1_transform_load.pbix from the Exercises folder on the desktop.

This exercise is part of the course

Introduction to Power BI

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise