6.2 Power Query Editor Tour
| Area | Purpose |
|---|---|
| Ribbon | Tabs: Home, Transform, Add Column, View, Tools, Help |
| Queries pane (left) | List of all queries (tables, functions, parameters). Right-click for Duplicate, Reference, Enable load, Group |
| Data preview (centre) | Preview of the data (not all rows). Column header icons show the data type (ABC = text, 123 = whole number, 1.2 = decimal, calendar = date) |
| Formula bar | Shows the M code of the selected step (switch on via View › Formula Bar) |
| Query Settings pane (right) | Query Name and the list of Applied Steps |
| Status bar | Column/row counts and "Column profiling based on top 1000 rows" |
Ravindra Bagale's Tip
A common mistake is working without the formula bar and the data preview tools switched on. Turn on the Formula bar and Column quality/distribution/profile in the View tab. Seeing the M code of each step is the fastest way to learn and debug. Clear?
Ravindra Bagale's Tip – मराठी
एक common चूक म्हणजे formula bar आणि data preview tools चालू न करता काम करणं. View tab मध्ये Formula bar आणि Column quality/distribution/profile चालू करा. प्रत्येक step चा M code बघणं हा शिकण्याचा आणि debug करण्याचा सगळ्यात जलद मार्ग आहे. समजलं का?
Ravindra Bagale's Tip – हिंदी
एक common गलती है formula bar और data preview tools चालू किए बिना काम करना. View tab में Formula bar और Column quality/distribution/profile चालू करो. हर step का M code देखना सीखने और debug करने का सबसे तेज़ तरीका है. समझ आया?