Exploring diagnostics options
You can use the Query Diagnostics tool to carry out an assessment of your queries and the steps performed. This means that once you have created Power Query steps, you can initiate a session that records and analyzes all the steps performed before you end that session. You can record what happens at the query level or deep dive at the single-step level. In this recipe, we will see where to find the Query Diagnostics option and how to set up the environment before starting a session.
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:
- Click on Get data and select the Text/CSV connector.
- Browse to your local folder where you downloaded the
FactInternetSales
CSV file and open it. The following window with a preview of the data will...