Syntax Cube.Dimensions(**cube** as table) as table Description Returns a table containing the set of available dimensions within the cube. Each dimension is a table containing a set of dimension attributes and each dimension attribute is represented as a column in the dimension table. Dimensions can… Read More »Cube.Dimensions
Syntax CsvStyle.QuoteAfterDelimiter Description Quotes in a field are only significant immediately following the delimiter. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Accessing Data Functions / CsvStyle.QuoteAfterDelimiter
Syntax null Description ‘Less than’ range operator for SAP HANA input parameters. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Accessing Data Functions / SapHanaRangeOperator.LessThan
Syntax MySQL.Database(server as text, database as text, optional options as nullable record) as table Description Returns a table of SQL tables, views, and stored scalar functions available in a MySQL database on server server in the database instance named database. The port may be optionally… Read More »MySQL.Database
Syntax Xml.Document(contents as any, optional encoding as nullable number) as table Description Returns the contents of the XML document as a hierarchical table. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Accessing Data Functions / Xml.Document
Syntax Excel.Workbook(workbook as binary, optional useHeaders as nullable logical, optional delayTypes as nullable logical) as table Description Returns a record of Sheets from the Excel workbook. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Accessing Data Functions / Excel.Workbook
Syntax null Description ‘Gzip compressed bXML flattening mode’ option for MDX execution in SAP Business Warehouse. Recommended for low latency or high volume queries. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Accessing Data Functions / SapBusinessWarehouseExecutionMode.BasXmlGzip
Syntax Csv.Document(source as any, optional columns as any, optional delimiter as any, optional extraValues as nullable number, optional encoding as nullable number) as table Description Returns the contents of the CSV document as a table. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Accessing Data… Read More »Csv.Document
Syntax Cube.MeasureProperty(measure as any, propertyName as text) as any Description Returns the property propertyName of measure measure. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Accessing Data Functions / Cube.MeasureProperty
Syntax GoogleAnalytics.Accounts() as table Description Returns Google Analytics accounts that are accessible from the current credential. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Accessing Data Functions / GoogleAnalytics.Accounts