Power BI – Query Ribbon

In the Power Query Editor, the ribbon refers to the collection of tabs and tools that you can use to perform various data transformations and load data into your workbook. The ribbon is located at the top of the Power Query Editor window and is similar to the ribbons in other Microsoft Office applications.

The main tabs on the ribbon in the Power Query Editor include

• Home: This tab includes basic options such as copying and pasting data, renaming columns, and removing duplicates.
• Transform: This tab includes more advanced data transformations such as splitting columns, merging data, and pivoting data.
• Add Column: This tab includes options for adding new columns to your data, such as calculating the sum of multiple columns or concatenating text from multiple columns.
• View: This tab includes options for changing the way data is displayed in the Power Query Editor, such as switching between the grid view and the code view.
• Tools: This tab includes options for managing the Power Query Editor and its associated data sources, such as refreshing data, diagnosing problems, and setting options.
• Help: This tab includes options for accessing help and support resources, such as the Power Query Editor documentation and forums.

Home tab contains common query tasks.

Select New Source to begin the query-building process. The most common data sources appear in a menu.

Data transformation tasks are available on the Transform tab, including:

• Adding or removing columns
• Changing data types
• Splitting columns
• Other data-driven tasks

In the Add Column tab, you can add a column, format column data, and add custom columns. The Add Column tab can be seen in the following image.

You can toggle whether certain panes or windows are displayed using the View tab on the ribbon. The Advanced Editor is also displayed here. View is shown in the following image.