Extracting data
Similar to the previous recipe, you can extract subsets of data and information from columns in this recipe. In this recipe, we will see how we can easily extract information such as length, a selection of characters, or a range of data within the column. The idea is to show you how easy it is to perform these transformations quickly and intuitively.
Getting ready
For this recipe, you need to have Power BI Desktop running on your machine. You need to download the following file in a local folder:
FactInternetSalesCSV 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 Transform...
