Presentation Type: Presentation
The Power Query M Language is now the common data access layer across the MSBI platform including Analysis Services, Power BI, and Excel. This session will walk through examples of utilizing M queries in each of these products to access and enhance the value of source data. Within these examples, fundamental concepts will be described including query folding, parameters, and staging queries. Additionally, tools for developing and managing M queries will be reviewed including the Power Query SDK for Visual Studio and the Power Query M Language extension for Visual Studio Code.