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 M ⓘ
linked to: Power Query

Power Query M formula language ⓘ
linked to: Power Query
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 Formula Language ⓘ
linked to: Power Query
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 Azure Data Factory Power Query activity ⓘ
linked to: Power Query

Dataflows in Power Apps ⓘ
Dataflows in Power BI ⓘ
Excel Power Query ⓘ
linked to: Power Query

Microsoft Power Query ⓘ
linked to: Power Query

Power BI Desktop ⓘ
Power Query Online ⓘ
linked to: Power Query

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 ⓘ