Syntax SharePoint.Files(url as text, optional options as nullable record) as table Description Returns a table containing a row for each document found at the specified SharePoint site, url, and subfolders. Each row contains properties of the folder or file and a link to its content.… Read More »SharePoint.Files
Syntax Cube.AttributeMemberId(attribute as any) as any Description Returns the unique member identifier from a member property value. attribute. Returns null for any other values. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Accessing Data Functions / Cube.AttributeMemberId
Syntax SapHana.Database(**server** as text, optional **options** as nullable record) as table Description Returns a table of multidimensional packages from the SAP HANA database 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 /… Read More »SapHana.Database
Syntax Essbase.Cubes(url as text, optional options as nullable record) as table Description Returns a table of cubes grouped by Essbase server from an Essbase instance at APS server url. 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… Read More »Essbase.Cubes
Syntax SharePoint.Contents(url as text, optional options as nullable record) as table Description Returns a table containing a row for each folder and document found at the specified SharePoint site, url. Each row contains properties of the folder or file and a link to its content.… Read More »SharePoint.Contents
Syntax null Description ‘bXML flattening mode’ option for MDX execution in SAP Business Warehouse. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Accessing Data Functions / SapBusinessWarehouseExecutionMode.BasXml
Syntax Cube.MeasureProperties(cube as table) as table Description Returns a table containing the set of available properties for measures that are expanded 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.MeasureProperties
Syntax AzureStorage.DataLake(endpoint as text, optional options as nullable record) as table Description Returns a navigational table containing the documents found in the specified container and its subfolders at the account URL, endpoint, from an Azure Data Lake Storage filesystem. options may be specified to control… Read More »AzureStorage.DataLake
Syntax AdoDotNet.DataSource(providerName as text, connectionString as any, optional options as nullable record) as table Description Returns the schema collection for the ADO.NET data source with provider name providerName and connection string connectionString. connectionString can be text or a record of property value pairs. Property values… Read More »AdoDotNet.DataSource
Syntax Salesforce.Reports(optional loginUrl as nullable text, optional options as nullable record) as table Description Returns the reports on the Salesforce account provided in the credentials. The account will be connected through the provided environment loginUrl. If no environment is provided then the account will connect… Read More »Salesforce.Reports