Events
Power BI DataViz World Championships
14 Feb, 4 pm - 31 Mar, 4 pm
With 4 chances to enter, you could win a conference package and make it to the LIVE Grand Finale in Las Vegas
Learn morePower 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+).
Additional resources
Training
Module
Introduction and prerequisites for Power BI – Online workshop - Training
Steps of installing the required software on your computer so that you can complete this course.
Certification
Microsoft Certified: Power BI Data Analyst Associate - Certifications
Demonstrate methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Microsoft Power BI.