Data source prerequisites (Power Query)

Note: Power Query is known as Get & Transform in Excel 2016. Information provided here applies to both. To learn more, see Get & Transform in Excel 2016.

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

  • 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+)

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×