M
E35617
data transformation language
domain-specific language
functional programming language
query language
M is a functional data mashup and query language used in Microsoft Power BI and related tools for data transformation and preparation.
Statements (49)
| Predicate | Object |
|---|---|
| instanceOf |
data transformation language
ⓘ
domain-specific language ⓘ functional programming language ⓘ query language ⓘ |
| alsoKnownAs |
Power Query
ⓘ
surface form:
Power Query M
|
| canConnectTo |
files
ⓘ
online services ⓘ relational databases ⓘ web services ⓘ |
| designedFor |
business intelligence scenarios
ⓘ
data analysts ⓘ |
| developedBy | Microsoft ⓘ |
| executedBy |
Power Query
ⓘ
surface form:
Power Query engine
|
| hasFeature |
built-in library functions
ⓘ
custom connectors support ⓘ immutable values ⓘ lazy evaluation ⓘ let expressions ⓘ list types ⓘ record types ⓘ table types ⓘ type system ⓘ |
| inputFormat |
semi-structured data
ⓘ
structured data ⓘ |
| integratedWith |
Power BI
ⓘ
surface form:
Power BI Desktop
Power BI Service dataflows ⓘ |
| primaryUse | ETL in self-service BI ⓘ |
| programmingParadigm | functional ⓘ |
| supports |
column operations
ⓘ
custom functions ⓘ data aggregation ⓘ data cleansing ⓘ data filtering ⓘ data mashup ⓘ data preparation ⓘ data transformation ⓘ data type conversion ⓘ error handling ⓘ grouping ⓘ joins ⓘ query folding ⓘ row operations ⓘ |
| usedIn |
Power Query
ⓘ
surface form:
Azure Data Factory Power Query
Power Query ⓘ
surface form:
Excel Power Query
Microsoft Dataverse dataflows ⓘ Power Query ⓘ
surface form:
Microsoft Excel Get & Transform Data
Power BI ⓘ
surface form:
Microsoft Power BI
Power Query ⓘ SQL Server Analysis Services Tabular ⓘ |
Referenced by (2)
Full triples — surface form annotated when it differs from this entity's canonical label.