Managing columns
After connecting to a data source from Power Query and after having selected the table to which it is connected, it is best practice to reduce and delete all data that is not relevant for the preparation and transformation processes and therefore for reporting.
You have the possibility to choose the columns you want to work with, thereby reducing the amount of data involved. With this recipe, we will see how to quickly and intuitively select columns in order to speed up the data preparation process.
Getting ready
For this recipe, you need to download the FactResellerSales comma-separated values (CSV) file into your local folder.
In this example, we will refer to the C:\Data folder.
How to do it…
Once you have opened 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
FactResellerSalesCSV file and...
