Power Query interface overview in Power BI - Cell-by-Cell Formula Trace

Sample Data

This table lists the main parts of the Power Query interface and what each part does.

Cell	Value
A1	Step
B1	Action
C1	Description
A2	1
B2	Open Power Query Editor
C2	Launch the Power Query Editor from Power BI Desktop to start data transformation.
A3	2
B3	Navigator Pane
C3	Shows available data sources and tables to select for import.
A4	3
B4	Query Settings Pane
C4	Displays applied steps and properties of the selected query.
A5	4
B5	Ribbon
C5	Contains buttons for common data transformation tasks like filtering, sorting, and adding columns.
A6	5
B6	Data Preview
C6	Shows a preview of the data after each transformation step.

Formula Trace

N/A

Cell Reference Map

  A               B                      C
+----+----------------------+----------------------------------------------+
|Step| Action               | Description                                  |
+----+----------------------+----------------------------------------------+
| 1  | Open Power Query     | Launch the Power Query Editor from Power BI |
|    | Editor               | Desktop to start data transformation.        |
+----+----------------------+----------------------------------------------+
| 2  | Navigator Pane       | Shows available data sources and tables to  |
|    |                      | select for import.                           |
+----+----------------------+----------------------------------------------+
| 3  | Query Settings Pane  | Displays applied steps and properties of the|
|    |                      | selected query.                              |
+----+----------------------+----------------------------------------------+
| 4  | Ribbon               | Contains buttons for common data transformation|
|    |                      | tasks like filtering, sorting, and adding   |
|    |                      | columns.                                     |
+----+----------------------+----------------------------------------------+
| 5  | Data Preview         | Shows a preview of the data after each      |
|    |                      | transformation step.                         |
+----+----------------------+----------------------------------------------+

This map shows the main interface parts of Power Query listed in the sample data.

Result

  A               B                      C
+----+----------------------+----------------------------------------------+
|Step| Action               | Description                                  |
+----+----------------------+----------------------------------------------+
| 1  | Open Power Query     | Launch the Power Query Editor from Power BI |
|    | Editor               | Desktop to start data transformation.        |
+----+----------------------+----------------------------------------------+
| 2  | Navigator Pane       | Shows available data sources and tables to  |
|    |                      | select for import.                           |
+----+----------------------+----------------------------------------------+
| 3  | Query Settings Pane  | Displays applied steps and properties of the|
|    |                      | selected query.                              |
+----+----------------------+----------------------------------------------+
| 4  | Ribbon               | Contains buttons for common data transformation|
|    |                      | tasks like filtering, sorting, and adding   |
|    |                      | columns.                                     |
+----+----------------------+----------------------------------------------+
| 5  | Data Preview         | Shows a preview of the data after each      |
|    |                      | transformation step.                         |
+----+----------------------+----------------------------------------------+

This is how the Power Query interface overview looks as a simple table in a spreadsheet.

Sheet Trace Quiz - 3 Questions

What does the Navigator Pane in Power Query show?

A Available data sources and tables

B Applied steps of the query

C Preview of transformed data

D Buttons for data transformation tasks

Key Result

N/A - This topic is an interface overview without formulas.