Updated on

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


Odbc.InferOptions( connectionString as any ) as record


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.


Return the inferred SQL capabilities for a connection string.

// Output: record
Odbc.InferOptions( "dsn=your_dsn" )

Learn more about Odbc.InferOptions in the following articles:

Other functions related to Odbc.InferOptions are:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/odbc-inferoptions