Introduction to Power Query Editor

In Power BI Desktop, Power Query is available within Power Query Editor. There are several ways to access Power Query Editor, outlined as follows:

• Click the Transform data button from the Home tab, as illustrated in the following screenshot:

Figure 3.9 – Opening Power Query Editor from the ribbon in Power BI

• We can navigate directly to a specific table query in Power Query Editor by right-clicking the desired table from the Fields pane then clicking Edit query, as shown in the following screenshot:

Figure 3.10 – Navigating directly to a specific underlying query in Power Query Editor

Power Query Editor has the following sections:

3. The Ribbon bar
4. The Queries pane
5. The Query Settings pane
6. The Data View pane
7. The Status bar

   The following screenshot shows the preceding sections:

   Figure 3.11 – Sections of Power Query Editor

   In the next few sections...