Overview of Query in Power BI Desktop

  1. Home
  2. Overview of Query in Power BI Desktop

We use Power BI Desktop for not only connecting to the world of data but also creating foundational reports. Together with sharing your efforts with others who can use your work, and thereby expand their business intelligence efforts.

Types of Views in Power BI Desktop

  • Report view – Under report view, you can use queries to create and build compelling visualizations, arranged as you want them to be displayed, together with multiple pages, that you wish to share with others.
  • Data view – As per the data view we can see the data in your report in data model format, such that you can add measures, create new columns, and manage relationships.
  • Relationships view – The relationships view helps to get a graphical representation of the relationships that have been established in the data model, and manage or modify them as required.

Power Query Editor in Power BI Desktop

Power BI Desktop also has the Power Query Editor. You can use the Power Query Editor for connecting with one or many data sources, shape and transform the data to meet the specified requirements, and then load that model into Power BI Desktop.

  • Firstly, to get to Power Query Editor, select Edit Queries from the Home tab of Power BI Desktop.
  • Then, with no data connections, Power Query Editor appears as a blank pane, ready for data.
  • Once a query is loaded, Power Query Editor view becomes more interesting.
  • We can then connect to the Web data source, Power Query Editor loads information about the data, which you can then begin to shape

Appearance of Power Query Editor

Following are the ways in which Power Query Editor appears once a data connection is established.

The Query Ribbon

The query ribbon in Power Query Editor consists of four tabs: HomeTransformAdd Column, and View.

  • Home tab contains the common query tasks.
  • Transform tab provides access to common data transformation tasks, like Adding or removing columns, Changing data types, Splitting columns and Other data-driven tasks.
  • The Add Column tab provides additional tasks associated with adding a column, formatting column data, and adding custom columns.
  • The View tab on the ribbon is used to toggle whether certain panes or windows are displayed.

The Left (Queries) Pane

  • The left pane, or Queries pane, helps to display the number of active queries and the name of the query.
  • So, when you select a query from the left pane, its data is displayed in the center pane, where you can shape and transform the data to meet your needs.

The Center (Data) Pane

  • In the center pane, or Data pane, data from the selected query is displayed.
  • Moreover, this pane is where much of the work of the Query view is accomplished.

The Right (Query Settings) Pane

  • Firstly, the right pane, or Query Settings pane, is where all steps associated with a query are displayed. 
  • Also, the Applied Steps section of the Query Settings pane reflects the fact that we just changed the type of the Overall score column.

For more Details visit – Power Query Editor

Microsoft Exam DA-100 Free Practice Test
Menu