Using Diagnose as a Power Query step

In the previous recipes, you had the chance to see how to run a query diagnostic at the query level, but you also have the chance to investigate single Power Query steps, without running general diagnostics for the entire query, and then drill down to the step you are interested in. In this recipe, we will see how to use this feature and test a single step.

Getting ready

For this recipe, you need to download the FactInternetSales CSV file.

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.
3. Select the ProductKey column, click on the drop-down icon, and click on Number Filters and then...