Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Power BI and Microsoft Fabric are transitioning supported data source connections from legacy embedded ODBC drivers to Apache Arrow Database Connectivity (ADBC) drivers. ADBC provides a set of standard interfaces for interacting with Arrow data, which is especially efficient at fetching large datasets with minimal overhead and no serialization or copying. The ADBC drivers also incorporate security enhancements, such as memory safety and garbage collection.
You can adopt ADBC today per-connection, and administrators can control the default behavior at scale using a tenant setting that workspace admins can override for testing and validation.
Connectors and driver changes
The following table lists the connectors that are transitioning from embedded ODBC drivers to replacement drivers. In most cases, the replacement driver is an ADBC driver.
| Connector | Current driver | Replacement driver |
|---|---|---|
| Databricks | Simba Spark ODBC | Databricks ADBC |
| Azure Databricks | Simba Spark ODBC | Databricks ADBC |
| Dremio | Simba Drill ODBC | FlightSQL ADBC |
| Google BigQuery and Google BigQuery (Microsoft Entra ID) | Simba Google BigQuery ODBC | BigQuery ADBC |
| Hive | Simba Hive ODBC | Deprecated |
| Impala | Simba Impala ODBC | HiveServer2 ADBC |
| Snowflake | Simba Snowflake ODBC | Snowflake ADBC |
| Spark | Simba Spark ODBC | HiveServer2 ADBC |
Who is affected
You're affected if you use any of the connectors transitioning to ADBC (such as Databricks, Snowflake, or Google BigQuery) and:
- You haven't explicitly chosen an implementation in the connection (the
Implementationparameter isn't specified), or - Your organization wants centralized control over whether ADBC or ODBC is the default for supported connectors.
This default applies wherever you create a connection, including semantic models, Dataflows Gen2, and paginated reports.
How to migrate
You can migrate in three ways, ordered by how much control you want:
- Per-connection opt-in: Add
Implementation="2.0"to individual connections to validate ADBC at your own pace. - Tenant setting: Set the organization-wide default through the Admin portal.
- Workspace override: Override the tenant default at the workspace level for side-by-side validation.
Per-connection opt-in
You can opt in to ADBC by adding Implementation="2.0" to supported connections. This approach lets you validate ADBC at your own pace for individual connections.
For detailed instructions on opting in per-connection for a specific connector, see the connector-specific documentation linked in the Connectors and driver changes table.
Tenant setting
Tenant admins can set the organization's default using the Admin portal setting:
Users can connect to data sources by using Apache Arrow database connectivity (ADBC)
- Disabled (default): Selects the legacy ODBC drivers as the default option.
- Enabled: Selects the new ADBC drivers as the default option.
This setting also controls the Test Connection behavior for each connection type inside the tenant.
Workspace override
The tenant setting delegates to workspaces, so workspace admins can override the default and compare behaviors without modifying each individual connection. This approach allows side-by-side validation. For example, you can use one workspace to test ADBC defaults while keeping another workspace on ODBC defaults.
How the implementation is chosen
If you explicitly specify the Implementation parameter in the connection, that value always takes precedence over the tenant or workspace defaults.
The following table shows how the driver is selected:
| Condition | Driver used |
|---|---|
Implementation="2.0" |
ADBC |
Implementation not specified and workspace setting is On |
ADBC |
Implementation="1.0" |
ODBC |
Implementation not specified and workspace setting is Off |
ODBC |
Recommended migration checklist
- Pick a pilot workspace and enable ADBC there first using the workspace override to validate key datasets and refresh scenarios.
- For any critical connections you want to validate immediately, opt in per-connection with
Implementation="2.0". - Once validation is complete, decide whether to enable ADBC by default at the tenant level.
Key dates
- September 2026: Microsoft begins removing ODBC drivers from the service. If you need to stay on ODBC (
Implementation="1.0"or workspace setting Off), you must use a gateway to continue running queries with ODBC. - March 2027: The ODBC drivers referenced in this article no longer ship with Power BI Desktop or the gateway. If you want to retain ODBC functionality, you must use the February 2027 release or earlier.