Expression Functions

Functions for evaluating and working with expressions.

Diagnostics.ActivityId
Returns an opaque identifier for the currently-running evaluation.
Diagnostics.CorrelationId
Returns an opaque identifier to correlate incoming requests with outgoing ones.
Diagnostics.Trace
Writes a trace message if tracing is enabled and returns the provided value.
Error.Record
Creates an error record from the provided reason, message, detail, parameters, and error code values.
Expression.Constant
Returns the M source code representation of a constant value.
Expression.Evaluate
Evaluates a Power Query M expression provided as text at runtime.
Expression.Identifier
Returns the M source code representation of an identifier name.
ItemExpression.From
Returns the abstract syntax tree (AST) for the body of a function, normalized into an item expression.
RowExpression.Column
Returns an abstract syntax tree (AST) representing access to a column within a row expression.
RowExpression.From
Returns the abstract syntax tree (AST) for the body of a function, normalized into a row expression.
SqlExpression.SchemaFrom
Returns schema information from a SQL-related expression. Intended for internal use only.
SqlExpression.ToExpression
Converts a SQL query to M code using the provided environment of available identifiers. Intended for internal use only.