Archive

Function.InvokeAfter

Syntax Function.InvokeAfter(function as function, delay as duration) as any Description Returns the result of invoking function after duration delay has passed. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Function Values / Function.InvokeAfter

Function.From

Syntax Function.From(functionType as type, function as function) as function Description Takes a unary function function and creates a new function with the type functionType that constructs a list out of its arguments and passes it to function. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions /… Read More »Function.From

Function.ScalarVector

Syntax Function.ScalarVector(scalarFunctionType as type, vectorFunction as function) as function Description Returns a scalar function of type scalarFunctionType that invokes vectorFunction with a single row of arguments and returns its single output. Additionally, when the scalar function is repeatedly applied for each row of a table… Read More »Function.ScalarVector

Function.IsDataSource

Syntax Function.IsDataSource(function as function) as logical Description Returns whether or not function is considered a data source. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Function Values / Function.IsDataSource

Expression.Evaluate

Syntax Expression.Evaluate(document as text, optional environment as nullable record) as any Description Returns the result of evaluating an M expression document, with the available identifiers that can be referenced defined by environment. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Expression Functions / Expression.Evaluate

Expression.Constant

Syntax Expression.Constant(value as any) as text Description Returns the M source code representation of a constant value. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Expression Functions / Expression.Constant

Expression.Identifier

Syntax Expression.Identifier(name as text) as text Description Returns the M source code representation of an identifier name. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Expression Functions / Expression.Identifier

Diagnostics.ActivityId

Syntax Diagnostics.ActivityId() as nullable text Description Returns an opaque identifier for the currently-running evaluation. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Error Handling Functions / Diagnostics.ActivityId

Error.Record

Syntax Error.Record(reason as text, optional message as nullable text, optional detail as any) as record Description Returns an error record from the provided text values for reason, message and detail. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Error Handling Functions / Error.Record

TraceLevel.Error

Syntax null Description Returns 2, the value for Error trace level. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Error Handling Functions / TraceLevel.Error