Using M syntax and the Advanced Editor
Every step you perform in Power Query will translate into a line of M code. You usually realize what M code is after a while because you start using the features available from the UI at the beginning. Once you get more confident with Power Query steps, you become ready to explore the elements that lie behind them, learn how they work, and how you can create custom transformations by coding. In this recipe, we will see how to access M code and how steps are displayed in the Advanced Editor.
Getting ready
In 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:
Figure 7.1 – Text/CSV connector
- Browse to your local folder where you downloaded the
FactInternetSales.csvfile and open...
