Managing a diagnostics session
Once you set up the Query Diagnostics options as shown in the previous recipe, you can run a session and see what results you get thanks to this feature. In this recipe, we will perform some transformation steps, and then run a diagnostics session and observe the type of results.
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
FactInternetSalesCSV file and open it. A window with a preview of the data will pop up; click on Transform Data. - Browse to the Home tab and click on the Choose Columns button. The Choose Columns window will pop up. Flag the
ProductKey,OrderDateKey,SalesTerritoryKey,OrderQuantity,ProductStandardCost...
