Syntax Xml.Tables(contents as any, optional options as nullable record, optional encoding as nullable number) as table Description Returns the contents of the XML document as a nested collection of flattened tables. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Accessing Data Functions / Xml.Tables
Syntax HdInsight.Files(account as text, containerName as text) as table Description Returns a table containing a row for each blob file found at the container URL, account, from an Azure storage vault. Each row contains properties of the file and a link to its content. Reference… Read More »HdInsight.Files
Syntax AnalysisServices.Databases(server as text, optional options as nullable record) as table Description Returns databases on an Analysis Services instance, server. 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 »AnalysisServices.Databases
Syntax Html.Table(html as any, columnNameSelectorPairs as list, optional options as nullable record) 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 / Html.Table
Syntax CsvStyle.QuoteAlways Description Quotes in a field are always significant regardless of where they appear. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Accessing Data Functions / CsvStyle.QuoteAlways
Syntax Soda.Feed(url as text) as table Description Returns a table from the contents at the specified URL url formatted according to the SODA 2.0 API. The URL must point to a valid SODA-compliant source that ends in a .csv extension. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query… Read More »Soda.Feed
Syntax SapBusinessWarehouse.Cubes(server as text, systemNumberOrSystemId as text, clientId as text, optional optionsOrLogonGroup as any, optional options as nullable record) as table Description Returns a table of InfoCubes and queries grouped by InfoArea from an SAP Business Warehouse instance at server server with system number systemNumberOrSystemId… Read More »SapBusinessWarehouse.Cubes
Syntax null Description ‘Off’ distribution option for SAP HANA. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Accessing Data Functions / SapHanaDistribution.Off
Syntax AzureStorage.DataLakeContents(url as text, optional options as nullable record) as binary Description Returns the content of the file at the URL, url, from an Azure Data Lake Storage filesystem. 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 »AzureStorage.DataLakeContents
Syntax null Description Specifies the PUT 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.Put