M

E35617

M is a functional data mashup and query language used in Microsoft Power BI and related tools for data transformation and preparation.

Jump to: Statements Referenced by

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.