Types of Power Query M queries
In Chapter 2, Preparing Data Sources, SQL views were created, data sources configured, and the Power BI Desktop environment options applied. With these tasks accomplished, the dataset designer can finally start developing the data retrieval queries and parameters of the dataset. Power Query (M) queries are the means by which data sources are connected to and data imported into Power BI datasets. M queries are necessary to connect to data sources such as SQL views and can also perform data transformation as required.
The Power Query M language is a functional coding language more formally called the Power Query Formula Language. M includes over 700 functions that are used to connect to data and perform transformations of that data. The lines of M code that connect to and transform data are called a query.
There are a number of different types of queries that serve different purposes, including:
- Data source parameters
- Staging...