Power Query Editor

Data Preview Area(Center):
The Data Preview Area is located in the center of Power Query Editor. It displays the actual dataset in an tabular format(rows and columns).

Data Preview area helps:

• View the data

• Edit values

• Check data quality

• Apply transformations

Query Settings Pane(Right Side):
The Query Settings Pane is located on the right side of Power Query Editor. It display information about the selected query and all applied transformation steps.

Query Settings Pane helps:

• Shows the query name

Formula Bar:
The Formula Bar displays the Power Query M language code generated for each transformation.
Formula Bar hepls:

• View M code

• Edit transformations manually

• Create advanced data transformations

Column Headers:
Column Headers are located at the top of each column in the Data Preview Area.
Column Header helps:

• Display column names

• Show data types

• Access filtering and sorting options

Status Bar:
The status Bar is located at the bottom of Power Query Editor.
Status Bar helps:

• Number of rows

• Number of columns

• Query Loading status

• Data profiling information