Syntax Cube.Measures(**cube** as any) as table Description Returns a table containing the set of available measures within the cube. Each measure is represented as a function. Measures can be applied to the cube using Cube.AddMeasureColumn. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Accessing Data… Read More »Cube.Measures
Syntax Cube.DisplayFolders(**cube** as table) as table Description Returns a nested tree of tables representing the display folder hierarchy of the objects (e.g. dimensions and measures) available for use in 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.DisplayFolders
Syntax HdInsight.Contents(account as text) 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. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions /… Read More »HdInsight.Contents
Syntax OData.Feed(serviceUri as text, optional headers as nullable record, optional options as any) as any Description Returns a table of OData feeds offered by an OData service from a uri serviceUri, headers headers. A boolean value specifying whether to use concurrent connections or an optional… Read More »OData.Feed
Syntax Sybase.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 a Sybase database on server server in the database instance named database. The port may be optionally specified with the… Read More »Sybase.Database
Syntax Json.Document(jsonText as any, optional encoding as nullable number) as any Description Returns the content of the JSON document. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Accessing Data Functions / Json.Document
Syntax Oracle.Database(server as text, optional options as nullable record) as table Description Returns a table of SQL tables and views from the Oracle database on server server. The port may be optionally specified with the server, separated by a colon. An optional record parameter, options,… Read More »Oracle.Database
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 / Accessing Data Functions / Parquet.Document
Syntax HdInsight.Containers(account as text) 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. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions /… Read More »HdInsight.Containers
Syntax OleDb.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 OLE DB. connectionString can be text or a record of property value pairs. Property values can either be… Read More »OleDb.Query