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