Exploring Power Query Editor

The aim of this recipe is to illustrate and describe the different sections of Power Query. The tool's design is studied to offer you an intuitive experience, and it is important to understand its logic to get the biggest benefit from it.

Getting ready

For this recipe, you need to have Power BI Desktop running on your machine.

How to do it…

Once you have opened Power BI Desktop, perform the following steps:

1. Click on Transform data to open an empty Power Query interface:
   

   Figure 3.1 – Opening Power Query

2. Click on Enter data and create a table by creating two columns, ID and Value, and by entering values, as shown in the following screenshot:

   Figure 3.2 – Entering data

3. Click on OK.

   The idea is to have an example query to illustrate the different Power Query user interface (UI) sections because, in this way, you will have all the different buttons under each tab activated.

   It is possible to explore the Power...