Message Center

MC1402304Power Query tenant setting supports ODBC to ADBC transition

Summary

Microsoft will introduce a tenant-level setting to support transitioning Power Query from ODBC to ADBC, improving data connectivity performance. The rollout starts late June 2026, with the setting disabled by default initially. No immediate action is required, but reviewing and testing ADBC compatibility is recommended.

More information

What and Why:

Microsoft is introducing a new tenant-level setting to support the transition from ODBC (Open Database Connectivity) to ADBC (Arrow Database Connectivity) in Power Query. This change is part of Microsoft’s ongoing investment in improving data connectivity performance, reliability, and scalability. ADBC aligns with modern data access standards and helps deliver faster, more efficient data operations across your organization.

Rollout Schedule:

General Availability (Worldwide): Rollout begins late June 2026 and is expected to complete by late December 2026

Impact on Your Organization:

Who is affected:

  • Admins managing Power Query settings and data connectivity within the tenant
  • Users leveraging ODBC-based connections in Power Query (e.g., Excel, Power BI)

Platforms/Services:

  • Power Query (across Excel, Power BI, and other integrated Microsoft data experiences)

What will happen:

  • A new tenant setting for ODBC-to-ADBC transition will be visible in your tenant.
  • The setting is disabled by default at rollout.
  • Microsoft plans to enable this setting by default at a later date.
  • There is no immediate impact to users or existing workflows while the setting remains disabled.
  • Future enablement may transition eligible connections from ODBC to ADBC.

Action Required / Recommendations:

No immediate action is required. We recommend that you:

  • Review the new tenant setting once it becomes available.
  • Evaluate existing ODBC-based data connections.
  • Test ADBC compatibility in non-production environments.
  • Communicate upcoming changes to data and analytics teams.

Learn more: Transition to ADBC in Power Query

Compliance considerations:

No compliance considerations identified, review as appropriate for your organization.