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:
- Click on Transform data to open an empty Power Query interface:
- Click on Enter data and create a table by creating two columns,
ID
andValue
, and by entering values, as shown in the following screenshot: - 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...