Syntax Cube.CollapseAndRemoveColumns(**cube** as table, **columnNames** as list) as table Description Changes the dimensional granularity of the filter context for the cube by collapsing the attributes mapped to the specified columns columnNames. The columns are also removed from the tabular view of the cube. Reference Data… Read More »Cube.CollapseAndRemoveColumns
Syntax Folder.Files(path as text, optional options as nullable record) as table Description Returns a table containing a row for each file found at the folder path, path, and subfolders. 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 »Folder.Files
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 Query M Functions / Accessing Data Functions / Cube.ReplaceDimensions
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 Functions / Accessing Data Functions / WebMethod.Get
Syntax Hdfs.Contents(url as text) as table Description Returns a table containing a row for each folder and file found at the folder URL, url, from a Hadoop file system. Each row contains properties of the folder or file and a link to its content. Reference… Read More »Hdfs.Contents
Syntax Teradata.Database(server as text, optional options as nullable record) as table Description Returns a table of SQL tables and views from the Teradata database on server server. The port may be optionally specified with the server, separated by a colon. An optional record parameter, options,… Read More »Teradata.Database
Syntax Cdm.Contents(table as table) as table 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 / Cdm.Contents
Syntax Access.Database(database as binary, optional options as nullable record) as table Description Returns a structural representation of an Access database, database. 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… Read More »Access.Database
Syntax Sql.Databases(server as text, optional options as nullable record) as table Description Returns a table of databases on the specified SQL server, server. 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… Read More »Sql.Databases
Syntax AdoDotNet.Query(providerName as text, 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 the ADO.NET provider providerName. connectionString can be text or a record of property value pairs.… Read More »AdoDotNet.Query