Archive

Hdfs.Files

Syntax Hdfs.Files(url as text) as table Description Returns a table containing a row for each file found at the folder URL, url, and subfolders from a Hadoop file system. Each row contains properties of the file and a link to its content. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference… Read More »Hdfs.Files

SapHanaDistribution.Connection

Syntax null Description ‘Connection’ distribution option for SAP HANA. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Accessing Data Functions / SapHanaDistribution.Connection

ActiveDirectory.Domains

Syntax ActiveDirectory.Domains(optional forestRootDomainName as nullable text) as table Description Returns a list of Active Directory domains in the same forest as the specified domain or of the current machine’s domain if none is specified. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Accessing Data Functions… Read More »ActiveDirectory.Domains

SapHanaRangeOperator.GreaterThanOrEquals

Syntax null Description ‘Greater than or equals’ range operator for SAP HANA input parameters. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Accessing Data Functions / SapHanaRangeOperator.GreaterThanOrEquals

Web.Page

Syntax Web.Page(html as any) as table Description Returns the contents of the HTML document broken into its constituent structures, as well as a representation of the full document and its text after removing tags. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Accessing Data Functions… Read More »Web.Page

SapHanaRangeOperator.GreaterThan

Syntax null Description ‘Greater than’ range operator for SAP HANA input parameters. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Accessing Data Functions / SapHanaRangeOperator.GreaterThan

Web.BrowserContents

Syntax Web.BrowserContents(url as text, optional options as nullable record) as text Description This function is unavailable because it requires .NET 4.5. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Accessing Data Functions / Web.BrowserContents

SapHanaDistribution.Statement

Syntax null Description ‘Statement’ distribution option for SAP HANA. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Accessing Data Functions / SapHanaDistribution.Statement

Cube.AttributeMemberProperty

Syntax Cube.AttributeMemberProperty(attribute as any, propertyName as text) as any Description Returns the property propertyName of dimension attribute attribute. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Accessing Data Functions / Cube.AttributeMemberProperty

Identity.IsMemberOf

Syntax Identity.IsMemberOf(identity as record, collection as record) as logical Description Determines whether an identity is a member of an identity collection. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Accessing Data Functions / Identity.IsMemberOf