Power BI data source prerequisites

For data sources, Power BI supports specific provider versions and data source versions, and certain objects. For more information about available Power BI data sources, see Data sources.

The following table describes Power BI data source requirements.

Data source Provider Minimum provider version Minimum data source version Supported data source objects Download link
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 Download link
Excel (.xls files only) (see note 1) Microsoft Access Database Engine (ACE) ACE 2010 SP1 No restriction Tables, Sheets Download link
Oracle (see note 2) ODP.NET ODAC 11.2 Release 5 (11.2.0.3.20) 9.x+ Tables/Views Download link
MySQL Connector/Net 6.6.5 5.1 Tables/Views, Scalar functions Download link
PostgreSQL NPGSQL ADO.NET provider (Shipped with Power BI Desktop) 4.0.10 9.4 Tables/Views Download link
Teradata .NET Data Provider for Teradata 14+ 12+ Tables/Views Download link
SAP Sybase SQL Anywhere iAnywhere.Data.SQLAnywhere for .NET 3.5 16+ 16+ Tables/Views Download link

Note

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

Note

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