Syntax BinaryFormat.UnsignedInteger32(binary as binary) as any Description A binary format that reads a 32-bit unsigned integer. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Binary Functions / BinaryFormat.UnsignedInteger32
Syntax BinaryFormat.SignedInteger16(binary as binary) as any Description A binary format that reads a 16-bit signed integer. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Binary Functions / BinaryFormat.SignedInteger16
Syntax Excel.CurrentWorkbook() as table Description Returns the tables in the current 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.CurrentWorkbook
Syntax null Description Specifies the HEAD 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.Head
Syntax null Description Access is denied. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Accessing Data Functions / AccessControlKind.Deny
Syntax Cube.Parameters(cube as table) as table Description Returns a table containing the set of parameters that can be applied to cube. Each parameter is a function that can be invoked to get cube with the parameter and its arguments applied. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query… Read More »Cube.Parameters
Syntax Cube.PropertyKey(property as any) as any Description Returns the key of property property. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Accessing Data Functions / Cube.PropertyKey
Syntax Exchange.Contents (optional mailboxAddress as nullable text) as table Description Returns a table of contents from the Microsoft Exchange account mailboxAddress. If mailboxAddress is not specified, the default account for the credential will be used. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Accessing Data… Read More »Exchange.Contents
Syntax OleDb.DataSource(connectionString as any, optional options as nullable record) as table Description Returns a table of SQL tables and views from the OLE DB data source specified by the connection string connectionString. connectionString can be text or a record of property value pairs. Property values… Read More »OleDb.DataSource
Syntax null Description ‘DataStream 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.datastream