PowerQueryFormula

PowerQueryFormula class

Represents the definition of power query formula.

class PowerQueryFormula;

Properties

PropertyTypeDescription
groupNamestringReadonly. Gets the name of group which contains this power query formula.
namestringGets and sets the name of the power query formula.
descriptionstringGets and sets the description of the power query formula.
powerQueryFormulaItemsPowerQueryFormulaItemCollectionReadonly. Gets all items of power query formula.

Methods

MethodDescription
getGroupName()@deprecated. Please use the ‘groupName’ property instead. Gets the name of group which contains this power query formula.
getName()@deprecated. Please use the ’name’ property instead. Gets and sets the name of the power query formula.
setName(string)@deprecated. Please use the ’name’ property instead. Gets and sets the name of the power query formula.
getDescription()@deprecated. Please use the ‘description’ property instead. Gets and sets the description of the power query formula.
setDescription(string)@deprecated. Please use the ‘description’ property instead. Gets and sets the description of the power query formula.
getPowerQueryFormulaItems()@deprecated. Please use the ‘powerQueryFormulaItems’ property instead. Gets all items of power query formula.
isNull()Checks whether the implementation object is null.
getType()Gets the type of this power query formula.
getFormulaDefinition()Gets the definition of the power query formula.

groupName

Readonly. Gets the name of group which contains this power query formula.

groupName : string;

name

Gets and sets the name of the power query formula.

name : string;

description

Gets and sets the description of the power query formula.

description : string;

powerQueryFormulaItems

Readonly. Gets all items of power query formula.

powerQueryFormulaItems : PowerQueryFormulaItemCollection;

getGroupName()

@deprecated. Please use the ‘groupName’ property instead. Gets the name of group which contains this power query formula.

getGroupName() : string;

getName()

@deprecated. Please use the ’name’ property instead. Gets and sets the name of the power query formula.

getName() : string;

setName(string)

@deprecated. Please use the ’name’ property instead. Gets and sets the name of the power query formula.

setName(value: string) : void;

Parameters:

ParameterTypeDescription
valuestringThe value to set.

getDescription()

@deprecated. Please use the ‘description’ property instead. Gets and sets the description of the power query formula.

getDescription() : string;

setDescription(string)

@deprecated. Please use the ‘description’ property instead. Gets and sets the description of the power query formula.

setDescription(value: string) : void;

Parameters:

ParameterTypeDescription
valuestringThe value to set.

getPowerQueryFormulaItems()

@deprecated. Please use the ‘powerQueryFormulaItems’ property instead. Gets all items of power query formula.

getPowerQueryFormulaItems() : PowerQueryFormulaItemCollection;

Returns

PowerQueryFormulaItemCollection

isNull()

Checks whether the implementation object is null.

isNull() : boolean;

getType()

Gets the type of this power query formula.

getType() : PowerQueryFormulaType;

Returns

PowerQueryFormulaType

getFormulaDefinition()

Gets the definition of the power query formula.

getFormulaDefinition() : string;