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 moreThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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+).
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 moreTraining
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.
Documentation
Connect to data in Power BI Desktop - Power BI
Practice how to bring connect to data and transform it for use in Power BI Desktop by using sample data from the internet.
Data sources for the Power BI service - Power BI
Learn about different data sources and how to get and refresh data sources and semantic models in the Power BI service.
Power BI data sources - Power BI
This article lists the data sources that Power BI supports, including information about DirectQuery and the on-premises data gateway.