Archive

Uri.EscapeDataString

Syntax Uri.EscapeDataString(data as text) as text Description Encodes special characters in the input data according to the rules of RFC 3986. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Uri Functions / Uri.EscapeDataString

Type.ForFunction

Syntax Type.ForFunction(signature as record, min as number) as type Description Creates a function type from signature, a record of ReturnType and Parameters, and min, the minimum number of arguments required to invoke the function. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Type Functions /… Read More »Type.ForFunction

Type.TableColumn

Syntax Type.TableColumn(tableType as type, column as text) as type Description Returns the type of the column column in the table type tableType. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Type Functions / Type.TableColumn

Type.IsOpenRecord

Syntax Type.IsOpenRecord(type as type) as logical Description Returns a logical indicating whether a record type is open. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Type Functions / Type.IsOpenRecord

Type.TableKeys

Syntax Type.TableKeys(tableType as type) as list Description Returns the possibly empty list of keys for the given table type. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Type Functions / Type.TableKeys

Type.FunctionParameters

Syntax Type.FunctionParameters(type as type) as record Description Returns a record with field values set to the name of the parameters of type, and their values set to their corresponding types. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Type Functions / Type.FunctionParameters

Type.AddTableKey

Syntax Type.AddTableKey(table as type, columns as list, isPrimary as logical) as type Description Adds a key to the given table type. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Type Functions / Type.AddTableKey

Type.Facets

Syntax Type.Facets(type as type) as record Description Returns a record containing the facets of type Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Type Functions / Type.Facets

Type.TableRow

Syntax Type.TableRow(table as type) as type Description Type.TableRow Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Type Functions / Type.TableRow

Type.OpenRecord

Syntax Type.OpenRecord(type as type) as type Description Returns an opened version of the given record type (or the same type, if it is already opened). Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Type Functions / Type.OpenRecord