Connectors in Power Query
The following table contains a list of all the connectors currently available for Power Query. For those connectors that have a reference page in this document, a link is provided under the connector icon and name.
A checkmark indicates the connector is currently supported in the listed service; an X indicates that the connector is not currently supported in the listed service.
The connectors are listed in alphabetical order in separate tables for each letter in the alphabet. Use the In this article list on the right side of this article to go to any of the alphabetized tables. Go to Supported Azure data services to learn more about which connectors are supported by the VNET data gateway.
Note
The Excel column in the following table indicates all connectors that are available on at least one version of Excel. However, not all Excel versions support all of these indicated Power Query connectors. For a complete list of the Power Query connectors supported by all versions of Excel, go to Power Query data sources in Excel versions.
Note
There's a known issue resulting in an Expression.Error: The import [connector name] matches no exports
error where connectors requiring a gateway aren't working in dataflows and datamarts in Premium workspaces. There's ongoing work towards a fix and the documentation will be updated when a fix is released.
Note
Starting March 31, 2024, support for government cloud data sources using Organizational account will stop in non-governmental Power BI environments. To use government cloud data sources with organizational account, use the government Power BI environment.
A
Connector | Excel | Power BI (Semantic models) | Power BI (Dataflows) | Fabric (Dataflow Gen2) | Power Apps (Dataflows) | Customer Insights (Dataflows) |
Analysis Services |
---|---|---|---|---|---|---|---|
Access Database By Microsoft |
|||||||
Active Directory By Microsoft |
|||||||
Acterys (Beta) By Acterys |
|||||||
Actian (Beta) By Actian |
|||||||
Adobe Analytics By Microsoft |
|||||||
Amazon Athena By Amazon |
|||||||
Amazon OpenSearch Service (Beta) By Amazon |
|||||||
Amazon Redshift By Microsoft |
|||||||
Anaplan By Anaplan |
|||||||
appFigures (Beta) By Microsoft |
|||||||
Asana (Beta) By Asana |
|||||||
Assemble Views By Autodesk |
|||||||
AtScale cubes By Microsoft |
|||||||
Autodesk Construction Cloud By Autodesk |
|||||||
Automation Anywhere By Automation Anywhere |
|||||||
Automy Data Analytics (Beta) By ACEROYALTY |
|||||||
Azure Analysis Services database By Microsoft |
|||||||
Azure Blob Storage By Microsoft |
|||||||
Azure Cosmos DB By Microsoft |
|||||||
Azure Cosmos DB v2 (Beta) By Microsoft |
|||||||
Azure Cost Management By Microsoft |
|||||||
Azure Database for PostgreSQL By Microsoft |
|||||||
Azure Databricks By Databricks |
|||||||
Azure Data Explorer (Kusto) By Microsoft |
|||||||
Azure Data Lake Storage Gen1 By Microsoft |
|||||||
Azure Data Lake Storage Gen2 By Microsoft |
|||||||
Azure DevOps By Microsoft |
|||||||
Azure DevOps Server By Microsoft |
|||||||
Azure HDInsight (HDFS) By Microsoft |
|||||||
Azure HDInsight on AKS Trino (Beta) By Microsoft |
|||||||
Azure HDInsight Spark By Microsoft |
|||||||
Azure Resource Graph By Microsoft |
|||||||
Azure Synapse Analytics (SQL DW) By Microsoft |
|||||||
Azure Synapse Analytics workspace (Beta) By Microsoft |
|||||||
Azure SQL database By Microsoft |
|||||||
Azure Table Storage By Microsoft |
B
Connector | Excel | Power BI (Semantic models) | Power BI (Dataflows) | Fabric (Dataflow Gen2) | Power Apps (Dataflows) | Customer Insights (Dataflows) |
Analysis Services |
---|---|---|---|---|---|---|---|
BI Connector By Guidanz |
|||||||
BitSight Security Ratings By BitSight |
|||||||
Bloomberg Data and Analytics By Bloomberg |
|||||||
BQE Core By BQE |
|||||||
BuildingConnected (Beta) By Autodesk |
C
Connector | Excel | Power BI (Semantic models) | Power BI (Dataflows) | Fabric (Dataflow Gen2) | Power Apps (Dataflows) | Customer Insights (Dataflows) |
Analysis Services |
---|---|---|---|---|---|---|---|
CData Connect Cloud By CData |
|||||||
Celonis EMS By Celonis |
|||||||
Cherwell (Beta) By Cherwell |
|||||||
CloudBluePSA (Beta) By CloudBlue PSA (Beta) |
|||||||
Cognite Data Fusion By Cognite |
|||||||
Common Data Service (legacy) By Microsoft |
D
Connector | Excel | Power BI (Semantic models) | Power BI (Dataflows) | Fabric (Dataflow Gen2) | Power Apps (Dataflows) | Customer Insights (Dataflows) |
Analysis Services |
---|---|---|---|---|---|---|---|
Data.World - Get Dataset (Beta) By Microsoft |
|||||||
Data Virtuality LDW By Data Virtuality |
|||||||
Databricks By Databricks |
|||||||
Dataflows By Microsoft |
|||||||
Dataverse By Microsoft |
|||||||
Delta Sharing By Databricks |
|||||||
Denodo By Denodo |
|||||||
Digital Construction Works Insights By Digital Construction Works |
|||||||
Dremio Cloud By Dremio |
|||||||
Dremio Software By Dremio |
|||||||
Dynamics 365 Business Central By Microsoft |
|||||||
Dynamics 365 Business Central (on-premises) By Microsoft |
|||||||
Dynamics 365 Customer Insights (Beta) By Microsoft |
|||||||
Dynamics 365 (Dataverse) By Microsoft |
|||||||
Dynamics 365 Online (legacy) By Microsoft |
|||||||
Dynamics NAV By Microsoft |
E
Connector | Excel | Power BI (Semantic models) | Power BI (Dataflows) | Fabric (Dataflow Gen2) | Power Apps (Dataflows) | Customer Insights (Dataflows) |
Analysis Services |
---|---|---|---|---|---|---|---|
Eduframe Reporting (Beta) By Drieam |
|||||||
Emigo Data Source By Sagra |
|||||||
Emplifi Metrics (Deprecated) By Emplifi |
|||||||
Entersoft Business Suite (Beta) By Entersoft |
|||||||
EQuIS By EarthSoft |
|||||||
Essbase By Microsoft |
|||||||
eWay-CRM By eWay-CRM |
|||||||
Exasol By Exasol |
|||||||
Exact Online Premium By Exact Online |
|||||||
Excel By Microsoft |
1 |
1 Available in dataflows for Microsoft Teams.
F
Connector | Excel | Power BI (Semantic models) | Power BI (Dataflows) | Fabric (Dataflow Gen2) | Power Apps (Dataflows) | Customer Insights (Dataflows) |
Analysis Services |
---|---|---|---|---|---|---|---|
FactSet Analytics By FactSet |
|||||||
FactSet RMS (Beta) By FactSet |
|||||||
FHIR By Microsoft |
|||||||
Folder By Microsoft |
|||||||
Funnel By Funnel |
G
Connector | Excel | Power BI (Semantic models) | Power BI (Dataflows) | Fabric (Dataflow Gen2) | Power Apps (Dataflows) | Customer Insights (Dataflows) |
Analysis Services |
---|---|---|---|---|---|---|---|
Github (Beta) By Microsoft |
|||||||
Google Analytics By Microsoft |
|||||||
Google BigQuery By Microsoft |
|||||||
Google BigQuery (Microsoft Entra ID) (Beta) By Microsoft |
|||||||
Google Sheets By Microsoft |
H
Connector | Excel | Power BI (Semantic models) | Power BI (Dataflows) | Fabric (Dataflow Gen2) | Power Apps (Dataflows) | Customer Insights (Dataflows) |
Analysis Services |
---|---|---|---|---|---|---|---|
Hadoop File (HDFS) By Microsoft |
1 | 1 | |||||
HDInsight Interactive Query By Microsoft |
|||||||
Hexagon PPM Smart API By Hexagon PPM |
|||||||
Hive LLAP By Microsoft |
1 Doesn't support scheduled refresh of on-premises data sources in Power BI semantic models or Excel.
I
Connector | Excel | Power BI (Semantic models) | Power BI (Dataflows) | Fabric (Dataflow Gen2) | Power Apps (Dataflows) | Customer Insights (Dataflows) |
Analysis Services |
---|---|---|---|---|---|---|---|
IBM DB2 database By Microsoft |
|||||||
IBM Informix database (Beta) By Microsoft |
|||||||
IBM Netezza By Microsoft |
|||||||
Impala By Microsoft |
|||||||
Indexima By Indexima |
|||||||
Industrial App Store By Intelligent Plant |
|||||||
Information Grid (Beta) By Luminis |
|||||||
InterSystems Health Insight By Intersystems |
|||||||
InterSystems IRIS (Beta) By Intersystems |
|||||||
Intune Data Warehouse (Beta) By Microsoft |
|||||||
inwink By inwink |
J
Connector | Excel | Power BI (Semantic models) | Power BI (Dataflows) | Fabric (Dataflow Gen2) | Power Apps (Dataflows) | Customer Insights (Dataflows) |
Analysis Services |
---|---|---|---|---|---|---|---|
Jamf Pro (Beta) By Jamf |
|||||||
Jethro (Beta) By JethroData |
|||||||
JSON By Microsoft |
1 |
1 Available in dataflows for Microsoft Teams.
K
Connector | Excel | Power BI (Semantic models) | Power BI (Dataflows) | Fabric (Dataflow Gen2) | Power Apps (Dataflows) | Customer Insights (Dataflows) |
Analysis Services |
---|---|---|---|---|---|---|---|
Kognitwin By Kongsberg |
|||||||
KQL Database By Microsoft |
|||||||
Kyligence By Kyligence |
|||||||
Kyvos ODBC (Beta) By Kyvos Insights |
L
Connector | Excel | Power BI (Semantic models) | Power BI (Dataflows) | Fabric (Dataflow Gen2) | Power Apps (Dataflows) | Customer Insights (Dataflows) |
Analysis Services |
---|---|---|---|---|---|---|---|
Lakehouse (Beta) By Microsoft |
|||||||
LEAP (Beta) By LEAP |
|||||||
Linkar PICK Style/MultiValue Databases (Beta) By Kosday Solutions |
|||||||
LinkedIn Learning By LinkedIn |
|||||||
LinkedIn Sales Navigator (Beta) By Microsoft |
M
Connector | Excel | Power BI (Semantic models) | Power BI (Dataflows) | Fabric (Dataflow Gen2) | Power Apps (Dataflows) | Customer Insights (Dataflows) |
Analysis Services |
---|---|---|---|---|---|---|---|
Marketo (Beta) By Microsoft |
|||||||
MarkLogic By MarkLogic |
|||||||
MariaDB By MariaDB |
|||||||
Microsoft Azure Consumption Insights (Beta) (Deprecated) By Microsoft |
|||||||
Microsoft Exchange By Microsoft |
1 | 1 | |||||
Microsoft Exchange Online By Microsoft |
|||||||
Microsoft Graph Security (Deprecated) By Microsoft |
|||||||
Microsoft Teams Personal Analytics (Beta) By Microsoft |
|||||||
MicroStrategy for Power BI By MicroStrategy |
|||||||
Mixpanel (Beta) By Microsoft |
|||||||
MongoDB Atlas SQL interface By MongoDB |
|||||||
MySQL database By Microsoft |
1 Doesn't support scheduled refresh of on-premises data sources in Power BI semantic models or Excel.
O
Connector | Excel | Power BI (Semantic models) | Power BI (Dataflows) | Fabric (Dataflow Gen2) | Power Apps (Dataflows) | Customer Insights (Dataflows) |
Analysis Services |
---|---|---|---|---|---|---|---|
OData Feed By Microsoft |
1 | ||||||
ODBC By Microsoft |
|||||||
OneStream (Beta) By OneStream Software |
|||||||
OpenSearch Project (Beta) By OpenSearch |
|||||||
Oracle database By Microsoft |
1 Available in dataflows for Microsoft Teams.
P
Connector | Excel | Power BI (Semantic models) | Power BI (Dataflows) | Fabric (Dataflow Gen2) | Power Apps (Dataflows) | Customer Insights (Dataflows) |
Analysis Services |
---|---|---|---|---|---|---|---|
Parquet By Microsoft |
3 | ||||||
Palantir Foundry By Palantir |
|||||||
Paxata By Paxata |
|||||||
By Microsoft |
2 | 2 | 1 | ||||
Planview Enterprise Architecture By Planview |
|||||||
Planview IdeaPlace By Planview |
|||||||
Planview ORK (Beta) |
|||||||
Planview Portfolios By Planview |
|||||||
Planview Projectplace By Planview |
|||||||
PostgreSQL database By Microsoft |
|||||||
Power BI semantic models By Microsoft |
|||||||
Product Insights (Beta) By Microsoft |
|||||||
Profisee By Profisee |
|||||||
Python Script By Microsoft |
1 Available in dataflows for Microsoft Teams.
2 The PDF connector isn't supported in Power BI Premium.
3 The Parquet connector isn’t supported in the 32-bit version of Power BI Desktop.
Q
Connector | Excel | Power BI (Semantic models) | Power BI (Dataflows) | Fabric (Dataflow Gen2) | Power Apps (Dataflows) | Customer Insights (Dataflows) |
Analysis Services |
---|---|---|---|---|---|---|---|
QubolePresto (Beta) By Qubole |
|||||||
Quickbase By Quick Base |
|||||||
Quickbooks Online (Beta) By Microsoft |
R
Connector | Excel | Power BI (Semantic models) | Power BI (Dataflows) | Fabric (Dataflow Gen2) | Power Apps (Dataflows) | Customer Insights (Dataflows) |
Analysis Services |
---|---|---|---|---|---|---|---|
R Script By Microsoft |
|||||||
Roamler (Beta) By Roamler |
S
Connector | Excel | Power BI (Semantic models) | Power BI (Dataflows) | Fabric (Dataflow Gen2) | Power Apps (Dataflows) | Customer Insights (Dataflows) |
Analysis Services |
---|---|---|---|---|---|---|---|
Salesforce Objects By Microsoft |
|||||||
Salesforce Reports By Microsoft |
|||||||
Samsara By Samsara |
|||||||
SAP Business Warehouse Application Server By Microsoft |
|||||||
SAP Business Warehouse Message Server By Microsoft |
|||||||
SAP HANA database By Microsoft |
|||||||
SIS-CC SDMX (Beta) By SIS-CC |
|||||||
SharePoint folder By Microsoft |
|||||||
SharePoint list By Microsoft |
|||||||
SharePoint Online list By Microsoft |
1 | ||||||
Shortcuts Business Insights (Beta) By Shortcuts |
|||||||
SingleStore (Beta) By SingleStore |
|||||||
SiteImprove By SiteImprove |
|||||||
Smartsheet (Beta) By Smartsheet |
|||||||
Snowflake By Microsoft |
|||||||
Socialbakers Metrics (Deprecated) By Emplifi |
|||||||
SoftOneBI (Beta) By SoftOne |
|||||||
SolarWinds Service Desk By SolarWinds |
|||||||
Solver By BI360 |
|||||||
Spark By Microsoft |
|||||||
SparkPost (Beta) By Microsoft |
|||||||
SQL Server Analysis Services database By Microsoft |
|||||||
SQL Server database By Microsoft |
|||||||
Starburst Enterprise By Starburst Data |
|||||||
SumTotal By SumTotal |
|||||||
Supermetrics By Supermetrics |
|||||||
SurveyMonkey By SurveyMonkey |
|||||||
SweetIQ (Beta) By Microsoft |
|||||||
Sybase Database By Microsoft |
1 Available in dataflows for Microsoft Teams.
T
Connector | Excel | Power BI (Semantic models) | Power BI (Dataflows) | Fabric (Dataflow Gen2) | Power Apps (Dataflows) | Customer Insights (Dataflows) |
Analysis Services |
---|---|---|---|---|---|---|---|
TeamDesk (Beta) By ForeSoft |
|||||||
Tenforce (Smart)List By Tenforce |
|||||||
Teradata database By Microsoft |
|||||||
Text/CSV By Microsoft |
1 | ||||||
TIBCO(R) Data Virtualization By TIBCO |
|||||||
Twilio (Deprecated) (Beta) By Microsoft |
1 Available in dataflows for Microsoft Teams.
U
Connector | Excel | Power BI (Semantic models) | Power BI (Dataflows) | Fabric (Dataflow Gen2) | Power Apps (Dataflows) | Customer Insights (Dataflows) |
Analysis Services |
---|---|---|---|---|---|---|---|
Usercube (Beta) By Usercube |
V
Connector | Excel | Power BI (Semantic models) | Power BI (Dataflows) | Fabric (Dataflow Gen2) | Power Apps (Dataflows) | Customer Insights (Dataflows) |
Analysis Services |
---|---|---|---|---|---|---|---|
Vena By Vena |
|||||||
Vertica By Microsoft |
|||||||
Vessel Insight By Kongsberg |
|||||||
Viva Insights By Microsoft |
W
Connector | Excel | Power BI (Semantic models) | Power BI (Dataflows) | Fabric (Dataflow Gen2) | Power Apps (Dataflows) | Customer Insights (Dataflows) |
Analysis Services |
---|---|---|---|---|---|---|---|
Warehouse (Beta) By Microsoft |
|||||||
Web By Microsoft |
1 | ||||||
Webtrends Analytics (Beta) By Microsoft |
|||||||
Windsor (Beta) By Windsor.ai |
|||||||
Witivio (Beta) By Witivio |
|||||||
Wolters Kluwer CCH Tagetik By Wolters Kluwer |
|||||||
Workforce Dimensions (Beta) (Deprecated) By Kronos |
|||||||
Wrike (Beta) By Wrike |
1 Available in dataflows for Microsoft Teams.
X
Connector | Excel | Power BI (Semantic models) | Power BI (Dataflows) | Fabric (Dataflow Gen2) | Power Apps (Dataflows) | Customer Insights (Dataflows) |
Analysis Services |
---|---|---|---|---|---|---|---|
XML By Microsoft |
1 |
1 Available in dataflows for Microsoft Teams.
Z
Connector | Excel | Power BI (Semantic models) | Power BI (Dataflows) | Fabric (Dataflow Gen2) | Power Apps (Dataflows) | Customer Insights (Dataflows) |
Analysis Services |
---|---|---|---|---|---|---|---|
Zendesk (Beta) By Microsoft |
|||||||
Zendesk Data (Beta) By Zendesk |
|||||||
Zoho Creator By Zoho |
|||||||
Zucchetti HR Infinity (Beta) By Zucchetti |