Data source prerequisites (Power Query)

Use Excel's Get & Transform (Power Query) experience to connect to various data sources. 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

SAP Sybase SQL Anywhere

iAnywhere.Data.SQLAnywhere for .NET 3.5

16+

16+

  • Tables/Views

Link

DB2 for z/OS

  • Tables/Views

DB2 for i

  • Tables/Views

DB2 for LUW (Linux, UNIX, Windows)

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

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

See Also

Power Query is known as Get & Transform in Excel 2016

Import data from external data sources

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×