Įvykiai
Power BI DataViz Pasaulio čempionatas
02-14 16 - 03-31 16
Su 4 galimybes įvesti, galite laimėti konferencijos paketą ir padaryti jį LIVE Grand Finale Las Vegase
Sužinokite daugiauPower 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 |
Pastaba
Excel files that have an .xlsx extension do not require a separate provider installation.
Pastaba
The Oracle providers also require Oracle client software (version 8.1.7+).
Papildomi ištekliai
Mokymas
Modulis
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.
Sertifikatas
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.