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
Ek common chuk mhanje working without the formula bar and 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. Samjla ka?