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 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.
Examples
Return the inferred SQL capabilities for a connection string.
// Output: record
Odbc.InferOptions( "dsn=your_dsn" )
Related articles
Learn more about Odbc.InferOptions in the following articles:
- ODBC Data Sources, The SqlCapabilities Option And Power Query/Power BI Data Refresh Performance
The article highlights the impact of the “Supported row reduction clauses” option in Power Query for ODBC data sources on data refresh performance and the efficiency of the Power Query Editor. » Read more
Related functions
Other functions related to Odbc.InferOptions are:
2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy