Archive

AzureStorage.BlobContents

Syntax AzureStorage.BlobContents(url as text, optional options as nullable record) as binary Description Returns the content of the blob at the URL, url, from an Azure storage vault. 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… Read More »AzureStorage.BlobContents

Informix.Database

Syntax Informix.Database(server as text, database as text, optional options as nullable record) as table Description Returns a table of SQL tables and views available in an Informix database on server server in the database instance named database. The port may be optionally specified with the… Read More »Informix.Database

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

WebAction.Request

Syntax WebAction.Request(method as text, url as text, optional options as nullable record) as action Description Creates an action that, when executed, will return the results of performing a method request against url using HTTP as a binary value. An optional record parameter, options, may be… Read More »WebAction.Request

Cube.Transform

Syntax Cube.Transform(cube as table, transforms as list) as table Description Applies the list cube functions, transforms, on the cube. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Accessing Data Functions / Cube.Transform

AnalysisServices.Database

Syntax AnalysisServices.Database(server as text, database as text, optional options as nullable record) as table Description Returns a table of multidimensional cubes or tabular models from the Analysis Services database database on server server. An optional record parameter, options, may be specified to control the following… Read More »AnalysisServices.Database

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

IdentityProvider.Default

Syntax IdentityProvider.Default() as any Description The default identity provider for the current host. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Accessing Data Functions / IdentityProvider.Default

Odbc.DataSource

Syntax Odbc.DataSource(connectionString as any, optional options as nullable record) as table Description Returns a table of SQL tables and views from the ODBC data source specified by the connection string connectionString. connectionString can be text or a record of property value pairs. Property values can… Read More »Odbc.DataSource