Power Up Your BI with Supported Data Sources
Power BI: It is a business analytics service that allows you to connect to, visualize, and analyze data from a wide range of sources.
A wide variety of data sources are supported by Power BI. The available data connections are displayed when you click Get data. You can link to various SQL databases, flat files, the Azure cloud, or even web-based services like Facebook, Google Analytics, and Salesforce products. Additionally, it has an ODBC connection so that you can access unlisted ODBC data sources.
The Power BI data sources that are available are as follows:
The flat file
the SQL Database
Blank OData Feed Query
Online Services for the Azure Cloud Query
other data sources, including Active Directory, Exchange, or Hadoop
You must select the Get data option on the main screen of Power BI desktop in order to obtain data. It displays the most popular data sources.
Power BI supports the following data sources:
- Excel files
- CSV files
- Text files
- Folder
- PDF files
- XML files
- JSON files
- Web pages
- Azure SQL Database
- Azure SQL Data Warehouse
- Azure Synapse Analytics (formerly SQL DW)
- Azure Cosmos DB
- Azure HDInsight (Hive)
- Azure HDInsight Spark
- Azure Blob Storage
- Azure Data Lake Store
- Azure Data Lake Analytics
- Azure Table Storage
- Google BigQuery
- SAP HANA
- SAP Business Warehouse Server
- Amazon Redshift
- Teradata
- Oracle
- MySQL
- PostgreSQL
- Sybase
- DB2
- SQL Server
- SharePoint List
- OData feed
- Dynamics 365 (online)
- Dynamics NAV
- Dynamics 365 Business Central
- Salesforce Objects
- Salesforce Reports
- QuickBooks Online
- Zoho Analytics
- Magento
- Mailchimp
- Marketo
- Google Analytics
- Adobe Analytics
- appFigures
- Stripe
- Dynamics 365 Finance and Operations, Enterprise edition (on-premises)
- Dynamics AX (on-premises)
- Dynamics GP (on-premises)
- Dynamics SL (on-premises)
- Dynamics CRM (on-premises)
- OLE DB connection
- ODBC connection
This list is not exhaustive and new data sources are regularly added to Power BI. You can also use the Power BI REST API or the Power BI SDK to connect to other data sources or to create custom connectors.