6.1 What is Power Query?
Power Query is the data preparation (ETL) engine inside Power BI – and also inside Excel, Dataflows and Fabric. Every action you do with the mouse is recorded as a step written in the M language. When you refresh, Power Query replays all the steps on the latest data. So you clean the data once, and the process repeats automatically.
Open it with Home › Transform data.
Ravindra Bagale's Tip
Mitrano, khup students think Power Query changes the source file. It never does. It records steps and replays them on every refresh. Keep this in mind: clean in Power Query and leave your raw source untouched.