Power Query tenant setting supports ODBC to ADBC transition

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. 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. Message ID: MC1402304

The post Power Query tenant setting supports ODBC to ADBC transition appeared first on M365 Admin.