Category Archives: Microsoft PowerBI

Power BI Data Sources & Prerequisites

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)
  • Facebook
  • 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)
  • Facebook

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