Behind Power BI’s data load and transformation functionality is the M language. In this session you’ll learn what kind of scenarios you’ll need to use the M language as well as its basic syntax. You’ll also see several practical examples of how to use it, for example separating connection details out from queries to make them easy to update; creating and using functions; handling missing or changed data sources; and calling web services.
YOU MAY ALSO LIKE:
Introduction to M in Power BI
Chris Webb is an independent consultant specialising in Analysis Services, Power BI, M, MDX and DAX. He is the author of "Power Query for Power BI and Excel" and a co-author of "SQL Server Analysis Services 2012: The BISM Tabular Model", "Expert Cube Development with SQL Server 2008 Analysis Services", and "MDX Solutions with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase"; he also co-authored the white paper "Planning a Power BI Enterprise Deployment" for Microsoft. He blogs at http://blog.crossjoin.co.uk