6.1 What is Power Query?
In short: Power Query is the data preparation (ETL) engine inside Power BI – and also inside Excel, Dataflows and Fabric.
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
Friends, many 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.
Ravindra Bagale's Tip – मराठी
मित्रांनो, बऱ्याच students ना वाटतं Power Query source file बदलतो. तो कधीच बदलत नाही. तो steps record करतो आणि प्रत्येक refresh ला ते पुन्हा चालवतो. हे लक्षात ठेवा: Power Query मध्ये clean करा आणि raw source ला हात लावू नका.
Ravindra Bagale's Tip – हिंदी
दोस्तों, बहुत से students सोचते हैं कि Power Query source file बदल देता है. वह कभी नहीं बदलता. वह steps record करता है और हर refresh पर उन्हें दोबारा चलाता है. यह याद रखो: Power Query में clean करो और raw source को मत छेड़ो.