Archive

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 / Accessing Data Functions / Facebook.Graph

Syntax Odbc.Query(connectionString as any, query as text, optional options as nullable record) as table Description Returns the result of running query with the connection string connectionString using ODBC. connectionString can be text or a record of property value pairs. Property values can either be text… Read More »Odbc.Query

Syntax Sql.Database(server as text, database as text, optional options as nullable record) as table Description Returns a table of SQL tables, views, and stored functions from the SQL Server database database on server server. The port may be optionally specified with the server, separated by… Read More »Sql.Database

Syntax AzureStorage.Blobs(account as text, optional options as nullable record) as table Description Returns a navigational table containing a row for each container found at the account URL, account, from an Azure storage vault. Each row contains a link to the container blobs. options may be… Read More »AzureStorage.Blobs

Syntax Web.Contents(url as text, optional options as nullable record) as binary Description Returns the contents downloaded from url as binary. An optional record parameter, options, may be provided to specify additional properties. The record can contain the following fields: Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M… Read More »Web.Contents

Syntax null Description ‘Less 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.LessThanOrEquals

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 Functions / Accessing Data Functions / WebMethod.Delete

Syntax AdobeAnalytics.Cubes(optional options as nullable record) as table Description Returns a table of multidimensional packages from Adobe Analyics. An optional record parameter, options, may be specified to control the following options: Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Accessing Data Functions / AdobeAnalytics.Cubes

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 Data Functions / AccessControlKind.Allow

Syntax SharePoint.Tables(url as text, optional options as nullable record) as table Description Returns a table containing a row for each List item found at the specified SharePoint list, url. Each row contains properties of the List. options may be specified to control the following options:… Read More »SharePoint.Tables