Using Query Settings pane shortcuts 93
Through the Queries pane, you can quickly perform some common tasks and organize queries, especially when their number and complexity grow.
Using Query Settings pane shortcuts
One of the main benefits of Power Query is that every transformation is mapped and traced in the APPLIED STEPS pane. This is part of the Query Settings section, where you can see all the transformations and can perform some actions through a set of shortcuts.
The aim of this recipe is to explore the Query Settings section and explore possible activities.
Getting ready
For this recipe, you need to download the FactInternetSales CSV file into your local folder.
In this example, we will refer to the C:\Data folder.
How to do it…
Once you open your Power BI Desktop application, you are ready to perform the following steps:
1.Click on Get Data and select the Text/CSV connector.
2.Browse to your local folder where you downloaded the FactInternetSales CSV file and open it. A window with a preview of the data will pop up; click on
Transform data.
94Data Exploration in Power Query
3.Filter on the ProductKey column and select the values 310, 311, and 312:
Figure 3.39 – Filtering on ProductKey
4.Go to the Query Settings pane and observe the PROPERTIES and APPLIED STEPS sub-sections:
Figure 3.40 – Query Settings pane
Using Query Settings pane shortcuts 95
5.From the PROPERTIES sub-section, you can rename your query, and if you click on All Properties, the following window will pop up:
Figure 3.41 – Query Properties window
As already seen in the Using Queries pane shortcuts recipe, in this view you can rename a query, enter a query description, and flag/unflag some additional properties.
6.Focus now on the APPLIED STEPS sub-section, and right-click on the Filtered Rows step:
Figure 3.42 – APPLIED STEPS shortcuts