Favorite your Message Center and Roadmap items. Access them anytime via your Profile. Export and share with your team or your LLM.

Power Query tenant setting supports ODBC to ADBC transition

Message ID
MC1402304
View in Message Center
Service
Power BI
Category
Stay Informed
Tags
New featureUser impactAdmin impact
Rollout
June 2026July 2026August 2026September 2026October 2026November 2026December 2026

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.

Details

[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.

Change History

Show
No change history available

Never Miss a Microsoft 365 Update

Join thousands of IT professionals who rely on DeltaPulse for real-time Microsoft 365 change intelligence, automated notifications, and community insights.