Introduction
Using Power Bi desktop you have a lot of different sources you can pull data from. Below is a list of available data sources for Power BI Desktop.
Data Sources
File
- Excel
- CSV
- XML
- JSON
- Folder
- SharePoint Folder
Database
- SQL Server Database
- Access Database
- SQL Server Analysis Services Database
- Oracle Database
- IBM DB2 Database
- IBM Informix database (Beta)
- MySQL Database
- PostgreSQL Database
- Sybase Database
- Teradata Database
- SAP HANA Database
- SAP Business Warehouse server
- Amazon Redshift (Beta)
- Impala (Beta)
- Snowflake (Beta)
Azure
- Azure SQL Database
- Azure SQL Data Warehouse
- Azure Analysis Services database (Beta)
- Azure Data Marketplace
- Azure Blob Storage
- Azure Table Storage
- Azure DocumentDB (Beta)
- Azure Data Lake Store
- Azure HDInsight
- Azure HDInsight Spark (Beta)
Online Services
- Power BI service
- SharePoint Online List
- Microsoft Exchange Online
- Dynamics 365 (online)
- Dynamics 365 for Financials (Beta)
- Common Data Service (Beta)
- Azure Enterprise (Beta)
- Visual Studio Team Services (Beta)
- Salesforce Objects
- Salesforce Reports
- Google Analytics
- appFigures (Beta)
- comScore Digital Analytix (Beta)
- GitHub (Beta)
- Kusto (Beta)
- MailChimp (Beta)
- Marketo (Beta)
- Mixpanel (Beta)
- Planview Enterprise (Beta)
- Projectplace (Beta)
- QuickBooks Online (Beta)
- Smartsheet
- SparkPost (Beta)
- SQL Sentry (Beta)
- Stripe (Beta)
- SweetIQ (Beta)
- Troux (Beta)
- Twilio (Beta)
- tyGraph (Beta)
- Webtrends (Beta)
- Zendesk (Beta)
- PowerApps Common Data Service (Beta)
Other
- Web
- SharePoint List
- OData Feed
- Active Directory
- Microsoft Exchange
- Hadoop File (HDFS)
- Spark (Beta)
- R Script
- ODBC
- OLE DB
- Blank Query
Data Source Prerequisites
Each data provider has a minimum version required for Power BI to use.
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 |
System.Data.OracleClient (Built in .Net Framework) | .NET Framework 3.5 | 9.x+ | Tables/Views | Included in .NET Framework 3.5 or above | |
IBM DB2 | ADO.Net client from IBM (part of the IBM data server driver package) | 10.1 | 9.1+ | Tables/Views | Download link |
MySQL | Connector/Net | 6.6.5 | 5.1 | Tables/Views, Scalar functions | Download link |
PostgreSQL | NPGSQL ADO.NET provider | 2.0.12 | 7.4 | Tables/Views | Download link |
Teradata | .NET Data Provider for Teradata | 14+ | 12+ | Tables/Views | Download link |
Sybse IQ | iAnywhere.Data.SQLAnywhere for .NET 3.5 | 16+ | 16+ | Tables/Views | Download link |
Information Sourced from Power BI Documentation site
Power BI Data Source Prerequisites
Data sources in Power BI Desktop