Data Mashup with Microsoft Excel Using Power Query and M: Finding, Transforming, and Loading Data from External Sources

© Adam Aspin 2020

A. AspinData Mashup with Microsoft Excel Using Power Query and Mhttps://doi.org/10.1007/978-1-4842-6018-0_12

12. The M Language

Adam Aspin¹ 

(1)

Stafford, UK

 

Data ingestion and modification are not only interface-driven in Power Query. In fact, the entire process is underpinned and powered by a highly specific programming language. Called “M,” this language underlies everything that you have learned to do in the last 11 chapters.

Most users—most of the time—are unlikely to need to use the M language directly at all. This is because the Power Query Editor interface that you have learned so much about thus far in this book is both comprehensive and extremely intuitive. Yet there may be times when you will need to

• Add some additional ...