-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating

Power Query Cookbook
By :

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.
In this recipe, you need to download the FactInternetSales.csv
file.
In this example, we will refer to the C:\Data
folder.
Once you open your Power BI Desktop application, you are ready to perform the following steps:
Figure 7.1 – Text/CSV connector
FactInternetSales.csv
file and open...