Accessing Data Functions

Cube.PropertyKey

Syntax Cube.PropertyKey(property as any) as any Description Returns the key of property property. Reference Data …

Cube.Parameters

Syntax Cube.Parameters(cube as table) as table Description Returns a table containing the set of parameters …

AccessControlKind.Deny

Syntax null Description Access is denied. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Accessing …

WebMethod.Head

Syntax null Description Specifies the HEAD method for HTTP. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M …

Excel.CurrentWorkbook

Syntax Excel.CurrentWorkbook() as table Description Returns the tables in the current Excel workbook Reference Data …

SapBusinessWarehouseExecutionMode.BasXmlGzip

Syntax null Description ‘Gzip compressed bXML flattening mode’ option for MDX execution in SAP Business …

Excel.Workbook

Syntax Excel.Workbook(workbook as binary, optional useHeaders as nullable logical, optional delayTypes as nullable logical) as …

Xml.Document

Syntax Xml.Document(contents as any, optional encoding as nullable number) as table Description Returns the contents …

MySQL.Database

Syntax MySQL.Database(server as text, database as text, optional options as nullable record) as table Description …

SapHanaRangeOperator.LessThan

Syntax null Description ‘Less than’ range operator for SAP HANA input parameters. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference …

CsvStyle.QuoteAfterDelimiter

Syntax CsvStyle.QuoteAfterDelimiter Description Quotes in a field are only significant immediately following the delimiter. Reference …

Cube.Dimensions

Syntax Cube.Dimensions(**cube** as table) as table Description Returns a table containing the set of available …

Salesforce.Reports

Syntax Salesforce.Reports(optional loginUrl as nullable text, optional options as nullable record) as table Description Returns …

AdoDotNet.DataSource

Syntax AdoDotNet.DataSource(providerName as text, connectionString as any, optional options as nullable record) as table Description …

AzureStorage.DataLake

Syntax AzureStorage.DataLake(endpoint as text, optional options as nullable record) as table Description Returns a navigational …

Cube.MeasureProperties

Syntax Cube.MeasureProperties(cube as table) as table Description Returns a table containing the set of available …

SapBusinessWarehouseExecutionMode.BasXml

Syntax null Description ‘bXML flattening mode’ option for MDX execution in SAP Business Warehouse. Reference …

SharePoint.Contents

Syntax SharePoint.Contents(url as text, optional options as nullable record) as table Description Returns a table …

Essbase.Cubes

Syntax Essbase.Cubes(url as text, optional options as nullable record) as table Description Returns a table …

SapHana.Database

Syntax SapHana.Database(**server** as text, optional **options** as nullable record) as table Description Returns a table …

Cube.AttributeMemberId

Syntax Cube.AttributeMemberId(attribute as any) as any Description Returns the unique member identifier from a member …

SharePoint.Files

Syntax SharePoint.Files(url as text, optional options as nullable record) as table Description Returns a table …

sapbusinesswarehouseexecutionmode.datastream

Syntax null Description ‘DataStream flattening mode’ option for MDX execution in SAP Business Warehouse. Reference …

OleDb.DataSource

Syntax OleDb.DataSource(connectionString as any, optional options as nullable record) as table Description Returns a table …

Exchange.Contents

Syntax Exchange.Contents (optional mailboxAddress as nullable text) as table Description Returns a table of contents …

AnalysisServices.Database

Syntax AnalysisServices.Database(server as text, database as text, optional options as nullable record) as table Description …

Cube.Transform

Syntax Cube.Transform(cube as table, transforms as list) as table Description Applies the list cube functions, …

AccessControlEntry.ConditionToIdentities

Syntax AccessControlEntry.ConditionToIdentities(identityProvider as function, condition as function) as list Description Using the specified identityProvider, converts …

WebAction.Request

Syntax WebAction.Request(method as text, url as text, optional options as nullable record) as action Description …

WebMethod.Post

Syntax null Description Specifies the POST method for HTTP. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M …

Informix.Database

Syntax Informix.Database(server as text, database as text, optional options as nullable record) as table Description …

AzureStorage.BlobContents

Syntax AzureStorage.BlobContents(url as text, optional options as nullable record) as binary Description Returns the content …

AdoDotNet.Query

Syntax AdoDotNet.Query(providerName as text, connectionString as any, query as text, optional options as nullable record) …

Sql.Databases

Syntax Sql.Databases(server as text, optional options as nullable record) as table Description Returns a table …

Access.Database

Syntax Access.Database(database as binary, optional options as nullable record) as table Description Returns a structural …

Cdm.Contents

Syntax Cdm.Contents(table as table) as table Description This function is unavailable because it requires .NET …

Teradata.Database

Syntax Teradata.Database(server as text, optional options as nullable record) as table Description Returns a table …

Hdfs.Contents

Syntax Hdfs.Contents(url as text) as table Description Returns a table containing a row for each …

WebMethod.Get

Syntax null Description Specifies the GET method for HTTP. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M …

Cube.ReplaceDimensions

Syntax Cube.ReplaceDimensions(cube as table, dimensions as table) as table Description Cube.ReplaceDimensions Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power …

Folder.Files

Syntax Folder.Files(path as text, optional options as nullable record) as table Description Returns a table …

Cube.CollapseAndRemoveColumns

Syntax Cube.CollapseAndRemoveColumns(**cube** as table, **columnNames** as list) as table Description Changes the dimensional granularity of …

GoogleAnalytics.Accounts

Syntax GoogleAnalytics.Accounts() as table Description Returns Google Analytics accounts that are accessible from the current …

Cube.MeasureProperty

Syntax Cube.MeasureProperty(measure as any, propertyName as text) as any Description Returns the property propertyName of …

Csv.Document

Syntax Csv.Document(source as any, optional columns as any, optional delimiter as any, optional extraValues as …

SapBusinessWarehouse.Cubes

Syntax SapBusinessWarehouse.Cubes(server as text, systemNumberOrSystemId as text, clientId as text, optional optionsOrLogonGroup as any, optional …

Soda.Feed

Syntax Soda.Feed(url as text) as table Description Returns a table from the contents at the …

CsvStyle.QuoteAlways

Syntax CsvStyle.QuoteAlways Description Quotes in a field are always significant regardless of where they appear. …

Html.Table

Syntax Html.Table(html as any, columnNameSelectorPairs as list, optional options as nullable record) as table Description …

AnalysisServices.Databases

Syntax AnalysisServices.Databases(server as text, optional options as nullable record) as table Description Returns databases on …

HdInsight.Files

Syntax HdInsight.Files(account as text, containerName as text) as table Description Returns a table containing a …

Xml.Tables

Syntax Xml.Tables(contents as any, optional options as nullable record, optional encoding as nullable number) as …

SharePoint.Tables

Syntax SharePoint.Tables(url as text, optional options as nullable record) as table Description Returns a table …

AccessControlKind.Allow

Syntax null Description Access is allowed. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Accessing …

AdobeAnalytics.Cubes

Syntax AdobeAnalytics.Cubes(optional options as nullable record) as table Description Returns a table of multidimensional packages …

WebMethod.Delete

Syntax null Description Specifies the DELETE method for HTTP. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M …

SapHanaRangeOperator.LessThanOrEquals

Syntax null Description ‘Less than or equals’ range operator for SAP HANA input parameters. Reference …

Web.Contents

Syntax Web.Contents(url as text, optional options as nullable record) as binary Description Returns the contents …

AzureStorage.Blobs

Syntax AzureStorage.Blobs(account as text, optional options as nullable record) as table Description Returns a navigational …

Sql.Database

Syntax Sql.Database(server as text, database as text, optional options as nullable record) as table Description …

Odbc.Query

Syntax Odbc.Query(connectionString as any, query as text, optional options as nullable record) as table Description …

Facebook.Graph

Syntax Facebook.Graph(url as text) as any Description Important Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions …

Odbc.DataSource

Syntax Odbc.DataSource(connectionString as any, optional options as nullable record) as table Description Returns a table …

IdentityProvider.Default

Syntax IdentityProvider.Default() as any Description The default identity provider for the current host. Reference Data …

WebMethod.Patch

Syntax null Description Specifies the PATCH method for HTTP. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M …

Web.BrowserContents

Syntax Web.BrowserContents(url as text, optional options as nullable record) as text Description This function is …

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 …

Web.Page

Syntax Web.Page(html as any) as table Description Returns the contents of the HTML document broken …

SapHanaRangeOperator.GreaterThanOrEquals

Syntax null Description ‘Greater than or equals’ range operator for SAP HANA input parameters. Reference …

ActiveDirectory.Domains

Syntax ActiveDirectory.Domains(optional forestRootDomainName as nullable text) as table Description Returns a list of Active Directory …

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 …

Hdfs.Files

Syntax Hdfs.Files(url as text) as table Description Returns a table containing a row for each …

Cube.AddMeasureColumn

Syntax Cube.AddMeasureColumn(**cube** as table, **column** as text, **measureSelector** as any) as table Description Adds a …

Odbc.InferOptions

Syntax Odbc.InferOptions(connectionString as any) as record Description Returns the result of trying to infer SQL …

Folder.Contents

Syntax Folder.Contents(path as text, optional options as nullable record) as table Description Returns a table …

File.Contents

Syntax File.Contents(path as text, optional options as nullable record) as binary Description Returns the contents …

Identity.From

Syntax Identity.From(identityProvider as function, value as any) as record Description Creates an identity. Reference Data …

DB2.Database

Syntax DB2.Database(server as text, database as text, optional options as nullable record) as table Description …

RData.FromBinary

Syntax RData.FromBinary(stream as binary) as any Description Returns a record of data frames from the …

SapHanaRangeOperator.Equals

Syntax null Description ‘Equals’ range operator for SAP HANA input parameters. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power …

Pdf.Tables

Syntax Pdf.Tables(pdf as binary, optional options as nullable record) as table Description This function is …

Salesforce.Data

Syntax Salesforce.Data(optional loginUrl as any, optional options as nullable record) as table Description Returns the …

WebMethod.Put

Syntax null Description Specifies the PUT method for HTTP. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M …

AzureStorage.DataLakeContents

Syntax AzureStorage.DataLakeContents(url as text, optional options as nullable record) as binary Description Returns the content …

SapHanaDistribution.Off

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

Cube.AddAndExpandDimensionColumn

Syntax Cube.AddAndExpandDimensionColumn(**cube** as table, **dimensionSelector** as any, **attributeNames** as list, optional **newColumnNames** as any) as …

SapHanaDistribution.All

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

AzureStorage.Tables

Syntax AzureStorage.Tables(account as text) as table Description Returns a navigational table containing a row for …

Cube.Properties

Syntax Cube.Properties(cube as table) as table Description Returns a table containing the set of available …

PostgreSQL.Database

Syntax PostgreSQL.Database(server as text, database as text, optional options as nullable record) as table Description …

Cube.ApplyParameter

Syntax Cube.ApplyParameter(cube as table, parameter as any, optional arguments as nullable list) as table Description …

ODataOmitValues.Nulls

Syntax null Description Allows the OData service to omit null values. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power …

OleDb.Query

Syntax OleDb.Query(connectionString as any, query as text, optional options as nullable record) as table Description …

HdInsight.Containers

Syntax HdInsight.Containers(account as text) as table Description Returns a navigational table containing a row for …

Parquet.Document

Syntax null Description Parquet.Document(binary as binary) as any Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions …

Oracle.Database

Syntax Oracle.Database(server as text, optional options as nullable record) as table Description Returns a table …

Json.Document

Syntax Json.Document(jsonText as any, optional encoding as nullable number) as any Description Returns the content …

Sybase.Database

Syntax Sybase.Database(server as text, database as text, optional options as nullable record) as table Description …

OData.Feed

Syntax OData.Feed(serviceUri as text, optional headers as nullable record, optional options as any) as any …

HdInsight.Contents

Syntax HdInsight.Contents(account as text) as table Description Returns a navigational table containing a row for …

Cube.DisplayFolders

Syntax Cube.DisplayFolders(**cube** as table) as table Description Returns a nested tree of tables representing the …

Cube.Measures

Syntax Cube.Measures(**cube** as any) as table Description Returns a table containing the set of available …

Identity.IsMemberOf

Syntax Identity.IsMemberOf(identity as record, collection as record) as logical Description Determines whether an identity is …

Cube.AttributeMemberProperty

Syntax Cube.AttributeMemberProperty(attribute as any, propertyName as text) as any Description Returns the property propertyName of …

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 …