Data source prerequisites (Power Query)

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. For guidance on importing data from various sources, see Import data from external data sources.

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, Power BI



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language