Power BI Data Sources

We shall present the table that shows the Power BI data source that support for datasets, including information about DirectQuery and the on-premises data gateway. Learn about Power BI Data Source.

Data source	Connect from Desktop	Connect and refresh from service	DirectQuery / Live connection	Gateway (supported)	Gateway (required)	Power BI Dataflows
Access database	Yes	Yes	No	Yes ¹	Yes	Yes
ActiveDirectory	Yes	Yes	No	Yes	Yes	Yes
Adobe Analytics	Yes	Yes	No	No	No	No
Amazon Redshift	Yes	Yes	Yes	Yes	No	Yes
appFigures	Yes	Yes	No	No	No	No
AtScale cubes	Yes	Yes	Yes	Yes	No	No
Azure Analysis Services	Yes	Yes	Yes	No	No	No
Azure Blob Storage	Yes	Yes	No	Yes	No	Yes
Azure Cosmos DB	Yes	Yes	No	No	No	No
Azure Cost Management	Yes	Yes	No	No	No	No
Azure Data Explorer (kusto)	Yes	Yes	Yes	Yes	No	Yes
Azure Data Lake Storage Gen1	Yes	Yes	No	No	No	No
Azure Data Lake Storage Gen2	Yes	Yes	No	Yes	No	Yes
Azure Databricks	Yes	Yes	Yes	Yes	No	No
Azure DevOps	Yes	Yes	No	No	No	No
Azure DevOps Server	Yes	Yes	No	Yes	Yes	No
Azure HDInsight (HDFS)	Yes	Yes	No	No	No	No
Azure HDInsight Spark	Yes	Yes	Yes	No	No	Yes
Azure SQL Database	Yes	Yes	Yes	Yes	No	Yes
Azure SQL Data Warehouse	Yes	Yes	Yes	Yes	No	Yes
Azure Table Storage	Yes	Yes	No	Yes	No	Yes
BI Connector	Yes	Yes	Yes	Yes	Yes	No
BI360 – Budgeting & Financial Reporting	Yes	Yes	No	No	No	No
Microsoft Dataverse	Yes	Yes	No	No	No	Yes
Data.World – Get Dataset	Yes	Yes	No	No	No	No
Denodo	Yes	Yes	Yes	Yes	Yes	No
Dremio	Yes	Yes	Yes	Yes	Yes	No
Dynamics 365 (online)	Yes	Yes	No	No	No	No
Dynamics 365 Business Central	Yes	Yes	No	No	No	No
Dynamics 365 Business Central (on-premises)	Yes	Yes	No	No	No	No
Dynamics 365 Customer Insights	Yes	Yes	No	No	No	No
Dynamics NAV	Yes	Yes	No	No	No	No
Emigo Data Source	Yes	Yes	No	No	No	No
Entersoft Business Suite	Yes	Yes	No	No	No	No
Essbase	Yes	Yes	Yes	Yes	Yes	No
Exasol	Yes	Yes	Yes	Yes	Yes	No
Excel	Yes ³	Yes ³	No	Yes ³	No ⁴	Yes
Facebook	Yes	Yes	No	No	No	No
File	Yes	Yes	No	Yes	Yes	Yes
Folder	Yes	Yes	No	Yes	Yes	Yes
GitHub	Yes	Yes	No	No	No	No
Google Analytics	Yes	Yes	No	No	No	No
Google BigQuery	Yes	Yes	Yes	Yes	No	Yes
Hadoop File (HDFS)	Yes	No	No	No	No	No
Hive LLAP	Yes	Yes	Yes	Yes	No	No
HDInsight Interactive Query	Yes	Yes	Yes	No	No	No
IBM DB2	Yes	Yes	Yes	Yes	No	Yes
IBM Informix Database	Yes	Yes	No	Yes	No	No
IBM Netezza	Yes	Yes	Yes	Yes	Yes	No
Impala	Yes	Yes	Yes	Yes	Yes	Yes
Indexima	Yes	Yes	Yes	Yes	Yes	No
Industrial App Store	Yes	Yes	No	No	No	No
Information Grid	Yes	Yes	No	No	No	No
Intersystems IRIS	Yes	Yes	Yes	Yes	Yes	No
Intune Data Warehouse	Yes	Yes	No	No	No	No
Jethro ODBC	Yes	Yes	Yes	Yes	Yes	No
JSON	Yes	Yes	No	Yes**	No ⁴	Yes
Kyligence Enterprise	Yes	Yes	Yes	Yes	Yes	No
MailChimp	Yes	Yes	No	No	No	No
Marketo	Yes	Yes	No	No	No	No
MarkLogic ODBC	Yes	Yes	Yes	Yes	Yes	No
Microsoft Azure Consumption Insights	Yes	Yes	No	No	No	No
Microsoft Exchange	Yes	Yes	No	Yes	No	No
Microsoft Exchange Online	Yes	Yes	No	No	No	Yes
Microsoft Graph Security	Yes	Yes	No	Yes	No	No
Mixpanel	Yes	Yes	No	No	No	No
MySQL	Yes	Yes	No	Yes	Yes	Yes
OData	Yes	Yes ⁷	No	Yes	No	Yes
ODBC	Yes	Yes	No	Yes	Yes	Yes
OleDb	Yes	Yes	No	Yes	Yes	No
Oracle	Yes	Yes	Yes	Yes	Yes	Yes
Paxata ⁸	Yes	Yes	No	Yes	No	No
PDF	Yes	Yes	No	Yes	No ⁴	Yes
Planview Enterprise One – CTM	Yes	Yes	No	No	No	No
Planview Enterprise One – PRM	Yes	Yes	No	No	No	No
Planview Projectplace	Yes	Yes	No	No	No	No
PostgreSQL	Yes	Yes	Yes	Yes	No	Yes
Power BI dataflows	Yes	Yes	No	No	No	Yes
Power BI datasets	Yes	Yes	Yes	No	No	No
Power platform dataflows	Yes	Yes	No	No	No	Yes
Python script	Yes	Yes ⁵	No	Yes ⁵	Yes	No
QubolePresto	Yes	Yes	Yes	Yes	Yes	No
Quick Base	Yes	Yes	No	Yes	Yes	No
QuickBooks Online	Yes	Yes	No	No	No	No
R script	Yes	Yes ⁵	No	Yes ⁵	No	No
Roamler	Yes	Yes	No	Yes	No	No
Salesforce Objects	Yes	Yes	No	No	No	Yes
Salesforce Reports	Yes	Yes	No	No	No	Yes
SAP Business Warehouse Message Server	Yes	Yes	Yes	Yes	Yes	Yes
SAP Business Warehouse Server	Yes	Yes	Yes	Yes	Yes	Yes
SAP HANA	Yes	Yes	Yes	Yes	Yes	Yes
SharePoint Folder	Yes	Yes	No	Yes	No ⁴	Yes
SharePoint List	Yes	Yes	No	Yes	No ⁴	Yes
SharePoint Online List	Yes	Yes	No	Yes	No	Yes
Smartsheet	Yes	Yes	No	No	No	Yes
Snowflake	Yes	Yes	Yes	Yes	No	Yes
Spark	Yes	Yes	Yes	Yes	No	Yes
SparkPost	Yes	Yes	No	No	No	No
SQL Server	Yes	Yes	Yes	Yes	Yes	Yes
SQL Server Analysis Services	Yes	Yes	Yes	Yes	Yes	No
Stripe	Yes	Yes	No	No	No	No
SurveyMonkey	Yes	Yes	No	Yes	No	No
SweetIQ	Yes	Yes	No	No	No	No
Sybase	Yes	Yes	No	Yes	Yes	Yes
TeamDesk	Yes	Yes	No	Yes	No	No
Tenforce	Yes	Yes	No	No	No	No
Teradata	Yes	Yes	Yes	Yes	Yes	Yes
Text/CSV	Yes	Yes	No	Yes	No ⁴	Yes
Twilio	Yes	Yes	No	No	No	No
tyGraph	Yes	Yes	No	No	No	No
Vertica	Yes	Yes	Yes	Yes	Yes	Yes
Web	Yes	Yes	No	Yes	Yes ⁶	Yes
Webtrends	Yes	Yes	No	No	No	No
Workforce Dimensions	Yes	Yes	No	Yes	No	No
XML	Yes	Yes	No	Yes	No ⁴	Yes
Zendesk	Yes	Yes	No	No	No	No

For more details visit – Power BI Data Source

Microsoft Exam PL-900 Free Practice Test

Power BI Data Sources

Prepare for Assured Success