Power Query Editor

Main Components of Power Query Editor

• Ribbon Panel: Contains all commands used for data cleaning and transformation.

• Queries Pane(Left Side): Displays all tables(queries) loaded into Power Query

• Data Preview Area(Center): Shows the actual dataset in rows and columns.

• Query Settings Pane(Right Side): Displays all transformations applied to the selected query.

• Formula Bar: Shows the Power Query M code generated for each transformation.

• Column Headers: Displays column names and data types.

• Status Bar: Displays information about the dataset.

Main Tabs in Ribbon Panel

• Home Tab - Used for basic data management operations.
  Eg: Close & Apply, Refresh Preview, Remove Rows, Keep Rows, Replace Values, Merge Queries, and Append Queries

• Transform Tab - Used to modify and transform data.
  Eg: Change Data Type, Split Column, Merge Columns, Pivot Column, Unpivot Column, and Format Text

• Add Column Tab - Used to create new columns.
  Eg: Custom Column, Conditional Column, Index Column, Date Column, and Duplicate Column

• View Tab - Used to control what is displayed in Power Query Editor.
  Eg: Formula Bar, Query Settings, Column Quality, Column Distribution, and Column Profile

Query Pane(Left Side):
The Queries Pane is located on the left side of the Power Query Editor. It display all the tables(queries)that have been loaded into Power BI.

Query Pane helps:

• View all loaded tables

• Switch between different queries

• Manage multiple datasets

• Rename queries for better understanding

• Works: Select Query, Renaming Query, and Delete Query