M language

E188108

M language is a functional, case-sensitive data mashup and transformation language used primarily in Microsoft Power Query for importing, shaping, and combining data from diverse sources.

All labels observed (1)

Label Occurrences
M language canonical 2

How this entity was disambiguated

Statements (56)

Predicate Object
instanceOf data mashup language
data transformation language
domain-specific language
functional programming language
allows editing queries via Advanced Editor in Power Query
alsoKnownAs Power Query
surface form: Power Query M

Power Query
surface form: Power Query M formula language
dataModel based on values, lists, records, and tables
developedBy Microsoft
documentationHostedAt Microsoft Learn
evaluationStrategy lazy evaluation with query folding to data sources
executionModel query-based
hasFeature automatic type detection
built-in data type conversion
lazy evaluation semantics
native support for CSV
native support for Excel workbooks
native support for JSON
native support for OData feeds
native support for XML
native support for relational databases
native support for text files
native support for web data sources
rich library of data connectors
step-based query definition
integratedWith Power Query user interface
isCaseSensitive true
isTuringComplete true
officialName Power Query
surface form: Power Query Formula Language
paradigm functional
primaryPurpose combining data
data mashup
data transformation
importing data from diverse sources
shaping data
supports custom functions
error handling with try expression
function types
higher-order functions
immutable values
let expressions
list types
pattern-based data transformation
query folding
record types
table types
type annotations
syntaxStyle expression-based
typeSystem static with gradual typing characteristics
usedIn Power Query
surface form: Azure Data Factory Power Query activity

Microsoft Dataverse dataflows
surface form: Dataflows in Power Apps

Power BI Service dataflows
surface form: Dataflows in Power BI

Power Query
surface form: Excel Power Query

Power Query
surface form: Microsoft Power Query

Power BI Desktop (Report Server optimized)
surface form: Power BI Desktop

Power Query
surface form: Power Query Online

How these facts were elicited

Referenced by (2)

Full triples — surface form annotated when it differs from this entity's canonical label.

Power Query hasComponent M language
Power Query uses M language