Syntax Salesforce.Data(optional loginUrl as any, optional options as nullable record) as table Description Returns the objects 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 to… Read More »Salesforce.Data
Syntax Pdf.Tables(pdf as binary, 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 / Pdf.Tables
Syntax null Description ‘Equals’ 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.Equals
Syntax RData.FromBinary(stream as binary) as any Description Returns a record of data frames from the RData file. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Accessing Data Functions / RData.FromBinary
Syntax DB2.Database(server as text, database as text, optional options as nullable record) as table Description Returns a table of SQL tables and views available in a Db2 database on server server in the database instance named database. The port may be optionally specified with the… Read More »DB2.Database
Syntax Identity.From(identityProvider as function, value as any) as record Description Creates an identity. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Accessing Data Functions / Identity.From
Syntax File.Contents(path as text, optional options as nullable record) as binary Description Returns the contents of the file, path, as binary. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Accessing Data Functions / File.Contents
Syntax Folder.Contents(path as text, optional options as nullable record) as table Description Returns a table containing a row for each folder and file found at the folder path, path. Each row contains properties of the folder or file and a link to its content. Reference… Read More »Folder.Contents
Syntax Odbc.InferOptions(connectionString as any) as record Description Returns the result of trying to infer SQL capbabilities with the connection string connectionString using ODBC. connectionString can be text or a record of property value pairs. Property values can either be text or number. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference… Read More »Odbc.InferOptions
Syntax Cube.AddMeasureColumn(**cube** as table, **column** as text, **measureSelector** as any) as table Description Adds a column with the name column to the cube that contains the results of the measure measureSelector applied in the row context of each row. Measure application is affected by changes… Read More »Cube.AddMeasureColumn