Odbc.InferOptions is a Power Query M function that attempts to infer SQL capabilities using an ODBC connection string. The function returns the result of the inference process.
Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365
Syntax
Odbc.InferOptions( connectionString as any ) as recordDescription
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.
Examples
Return the inferred SQL capabilities for a connection string.
// Output: record
Odbc.InferOptions( "dsn=your_dsn" )Related functions
Other functions related to Odbc.InferOptions are:
