Data source prerequisites

Microsoft Power Query for Excel supports a large number of data source providers. For each provider, Power Query supports a specific provider version and objects.

Data source Provider Min. provider version Min. data source version Supported data source objects Download
SQL Server ADO.net (built into .Net Framework) .Net Framework 3.5 (only) SQL Server 2005+
  • Tables/Views
  • Scalar functions
  • Table functions
Included in .NET Framework 3.5 or above
Access Microsoft Access Database Engine (ACE) ACE 2010 SP1 No restriction
  • Tables/Views
Link
Excel (.xls files only) 1 Microsoft Access Database Engine (ACE) ACE 2010 SP1 No restriction
  • Tables
  • Sheets
Link
Oracle 2 ODP.NET ODAC 11.2 Release 5 (11.2.0.3.20) 9.x+
  • Tables/Views
Link
System.Data.OracleClient (Built in .Net Framework) .NET Framework 3.5 9.x+
  • Tables/Views
Included in .NET Framework 3.5 or above
IBM DB2 ADO.Net client from IBM (part of the IBM data server driver package) 10.1 9.1+
  • Tables/Views
Link
MySQL Connector/Net 6.6.5 5.1
  • Tables/Views
  • Scalar functions
Link
PostgreSQL NPGSQL ADO.NET provider 2.0.12 7.x+
  • Tables/Views
Link
Teradata .NET Data Provider for Teradata 14+ 12+
  • Tables/Views
Link
Sybase IQ iAnywhere.Data.SQLAnywhere for .NET 3.5 16+ 16+
  • Tables/Views
Link


1 Excel files that have an .xlsx extension do not require a separate provider installation.

2 The Oracle providers also require Oracle client software (version 8.1.7+)

 
 
Applies to:
Excel 2013, Excel 2010