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 M
→
|
| canConnectTo |
files
→
online services → relational databases → web services → |
| designedFor |
business intelligence scenarios
→
data analysts → |
| developedBy |
Microsoft
→
|
| executedBy |
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 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 |
Azure Data Factory Power Query
→
Excel Power Query → Microsoft Dataverse dataflows → Microsoft Excel Get & Transform Data → Microsoft Power BI → Power Query → SQL Server Analysis Services Tabular → |
Referenced by (2)
| Subject (surface form when different) | Predicate |
|---|---|
|
Peter Lorre
→
|
notableWork |
|
Power BI
→
|
programmingLanguage |