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.
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.
A
| Connector | Excel | Power BI (Datasets) | Power BI (Dataflows) | 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 Project(Beta)By Amazon |
|
|
|
|
|
|
 Amazon Redshift By Microsoft |
|
|
|
|
|
|
 Anaplan By Anaplan |
|
|
|
|
|
|
 appFigures (Beta) By Microsoft |
|
|
|
|
|
|
 Asana By Asana |
|
|
|
|
|
|
 Assemble Views By Autodesk |
|
|
|
|
|
|
 AtScale cubes (Beta) By Microsoft |
|
|
|
|
|
|
 Autodesk Construction Cloud (Beta) 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 CosmosDB By Microsoft |
|
|
|
|
|
|
 Azure Cost Management By Microsoft |
|
|
|
|
|
|
 Azure Databricks By Databricks |
|
|
|
|
|
|
 Azure Data Explorer (Beta) By Microsoft |
|
|
|
|
|
|
 Azure Data Lake Storage Gen1 By Microsoft |
|
|
|
|
|
|
 Azure Data Lake Storage Gen2 By Microsoft |
|
|
|
|
|
|
 Azure DevOps (Beta) By Microsoft |
|
|
|
|
|
|
Azure DevOps Server(Beta) By Microsoft |
|
|
|
|
|
|
 Azure HDInsight (HDFS) By Microsoft |
|
|
|
|
|
|
 Azure HDInsight Spark 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 |
|
|
|
|
|
|
 Azure Time Series Insights (Beta) By Microsoft |
|
|
|
|
|
|
B
| Connector | Excel | Power BI (Datasets) | Power BI (Dataflows) | Power Apps (Dataflows) | Customer Insights (Dataflows) |
Analysis Services |
|---|---|---|---|---|---|---|
 BI Connector By Guidanz |
|
|
|
|
|
|
 BI360 By Solver Global |
|
|
|
|
|
|
 BitSight Security Ratings (Beta) By BitSight |
|
|
|
|
|
|
 Bloomberg Data and Analytics By Bloomberg |
|
|
|
|
|
|
 BQE Core (Beta) By BQE |
|
|
|
|
|
|
C
| Connector | Excel | Power BI (Datasets) | Power BI (Dataflows) | Power Apps (Dataflows) | Customer Insights (Dataflows) |
Analysis Services |
|---|---|---|---|---|---|---|
 Cherwell (Beta) By Cherwell |
|
|
|
|
|
|
 Cognite Data Fustion (Beta) By Cognite |
|
|
|
|
|
|
 Common Data Service (legacy) By Microsoft |
|
|
|
|
|
|
D
| Connector | Excel | Power BI (Datasets) | Power BI (Dataflows) | Power Apps (Dataflows) | Customer Insights (Dataflows) |
Analysis Services |
|---|---|---|---|---|---|---|
 Data.World - Get Dataset (Beta) By Microsoft |
|
|
|
|
|
|
 Data Virtuality (Beta) By Data Virtuality |
|
|
|
|
|
|
 Dataflows By Microsoft |
|
|
|
|
|
|
 Dataverse By Microsoft |
|
|
|
|
|
|
 Delta Sharing (Beta) By Databricks |
|
|
|
|
|
|
 Denodo By Denodo |
|
|
|
|
|
|
 Digital Construction Works Insights (Beta) By Digital Construction Works |
|
|
|
|
|
|
 Dremio By Dremio |
|
|
|
|
|
|
 Dynamics 365 (online) By Microsoft |
|
|
|
|
|
|
 Dynamics 365 Business Central By Microsoft |
|
|
|
|
|
|
 Dynamics 365 Business Central (on-premises) By Microsoft |
|
|
|
|
|
|
 Dynamics 365 Customer Insights (Beta) By Microsoft |
|
|
|
|
|
|
 Dynamics NAV By Microsoft |
|
|
|
|
|
|
E
| Connector | Excel | Power BI (Datasets) | Power BI (Dataflows) | Power Apps (Dataflows) | Customer Insights (Dataflows) |
Analysis Services |
|---|---|---|---|---|---|---|
 eWay-CRM By eWay-CRM |
|
|
|
|
|
|
 Emigo Data Source By Sagra |
|
|
|
|
|
|
 Entersoft Business Suite (Beta) By Entersoft |
|
|
|
|
|
|
 EQuIS (Beta) By EarthSoft |
|
|
|
|
|
|
Essbase By Microsoft |
|
|
|
|
|
|
 Exasol By Exasol |
|
|
|
|
|
|
 Excel By Microsoft |
|
|
|
1 |
|
|
1 Available in dataflows for Microsoft Teams.
F
| Connector | Excel | Power BI (Datasets) | Power BI (Dataflows) | Power Apps (Dataflows) | Customer Insights (Dataflows) |
Analysis Services |
|---|---|---|---|---|---|---|
 FactSet Analytics (Beta) By FactSet |
|
|
|
|
|
|
 FHIR By Microsoft |
|
|
|
|
|
|
 Folder By Microsoft |
|
|
|
|
|
|
G
| Connector | Excel | Power BI (Datasets) | Power BI (Dataflows) | Power Apps (Dataflows) | Customer Insights (Dataflows) |
Analysis Services |
|---|---|---|---|---|---|---|
 Github (Beta) By Microsoft |
|
|
|
|
|
|
 Google Analytics By Microsoft |
|
|
|
|
|
|
Google BigQuery By Microsoft |
|
|
|
|
|
|
 Google Sheets (Beta) By Microsoft |
|
|
|
|
|
|
H
| Connector | Excel | Power BI (Datasets) | Power BI (Dataflows) | Power Apps (Dataflows) | Customer Insights (Dataflows) |
Analysis Services |
|---|---|---|---|---|---|---|
Hadoop File (HDFS) By Microsoft |
|
|
|
|
|
|
 HDInsight Interactive Query By Microsoft |
|
|
|
|
|
|
 Hexagon PPM Smart API By Hexagon PPM |
|
|
|
|
|
|
 Hive LLAP By Microsoft |
|
|
|
|
|
|
I
| Connector | Excel | Power BI (Datasets) | Power BI (Dataflows) | 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 (Beta) By Indexima |
|
|
|
|
|
|
 Industrial App Store By Intelligent Plant |
|
|
|
|
|
|
 Information Grid (Beta) By Luminis |
|
|
|
|
|
|
 InterSystems IRIS (Beta) By Intersystems |
|
|
|
|
|
|
 Intune Data Warehouse (Beta) By Microsoft |
|
|
|
|
|
|
J
| Connector | Excel | Power BI (Datasets) | Power BI (Dataflows) | 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 (Datasets) | Power BI (Dataflows) | Power Apps (Dataflows) | Customer Insights (Dataflows) |
Analysis Services |
|---|---|---|---|---|---|---|
 Kognitwin (Beta) By Kongsberg |
|
|
|
|
|
|
 Kyligence By Kyligence |
|
|
|
|
|
|
L
| Connector | Excel | Power BI (Datasets) | Power BI (Dataflows) | Power Apps (Dataflows) | Customer Insights (Dataflows) |
Analysis Services |
|---|---|---|---|---|---|---|
 Linkar PICK Style/MultiValue Databases (Beta) By Kosday Solutions |
|
|
|
|
|
|
 LinkedIn Sales Navigator (Beta) By Microsoft |
|
|
|
|
|
|
M
| Connector | Excel | Power BI (Datasets) | Power BI (Dataflows) | 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 |
|
|
|
|
|
|
Microsoft Exchange Online By Microsoft |
|
|
|
|
|
|
 Microsoft Graph Security (Deprecated) By Microsoft |
|
|
|
|
|
|
 MicroStrategy for Power BI By MicroStrategy |
|
|
|
|
|
|
 Mixpanel (Beta) By Microsoft |
|
|
|
|
|
|
MySQL database By Microsoft |
|
|
|
|
|
|
O
| Connector | Excel | Power BI (Datasets) | Power BI (Dataflows) | Power Apps (Dataflows) | Customer Insights (Dataflows) |
Analysis Services |
|---|---|---|---|---|---|---|
 OData Feed By Microsoft |
|
|
|
1 |
|
|
ODBC By Microsoft |
|
|
|
|
|
|
 OLE DB By Microsoft |
|
|
|
|
|
|
 OpenSearch Project(Beta) By OpenSearch |
|
|
|
|
|
|
Oracle database By Microsoft |
|
|
|
|
|
|
1 Available in dataflows for Microsoft Teams.
P
| Connector | Excel | Power BI (Datasets) | Power BI (Dataflows) | Power Apps (Dataflows) | Customer Insights (Dataflows) |
Analysis Services |
|---|---|---|---|---|---|---|
 Parquet By Microsoft |
|
3 |
|
|
|
|
 Palantir FoundryBy Palantir |
|
|
|
|
|
|
 Paxata By Paxata |
|
|
|
|
|
|
 By Microsoft |
|
2 |
2 |
1 |
|
|
 Planview Enterprise One - CTM (Beta) By Planview |
|
|
|
|
|
|
Planview Enterprise One - PRM (Beta) By Planview |
|
|
|
|
|
|
PostgreSQL database By Microsoft |
|
|
|
|
|
|
 Power BI datasets By Microsoft |
|
|
|
|
|
|
 Product Insights (Beta) By Microsoft |
|
|
|
|
|
|
 Projectplace for Power BI (Beta) By Planview |
|
|
|
|
|
|
 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 (Datasets) | Power BI (Dataflows) | Power Apps (Dataflows) | Customer Insights (Dataflows) |
Analysis Services |
|---|---|---|---|---|---|---|
 QubolePresto Beta By Qubole |
|
|
|
|
|
|
 Quickbooks Online (Beta) By Microsoft |
|
|
|
|
|
|
 Quick Base By Quick Base |
|
|
|
|
|
|
R
| Connector | Excel | Power BI (Datasets) | Power BI (Dataflows) | Power Apps (Dataflows) | Customer Insights (Dataflows) |
Analysis Services |
|---|---|---|---|---|---|---|
 R Script By Microsoft |
|
|
|
|
|
|
 Roamler (Beta) By Roamler |
|
|
|
|
|
|
S
| Connector | Excel | Power BI (Datasets) | Power BI (Dataflows) | Power Apps (Dataflows) | Customer Insights (Dataflows) |
Analysis Services |
|---|---|---|---|---|---|---|
 Salesforce Objects By Microsoft |
|
|
|
|
|
|
Salesforce Reports By Microsoft |
|
|
|
|
|
|
SAP Business Warehouse Application Server By Microsoft |
|
|
|
|
|
|
SAP Business Warehouse Message Server By Microsoft |
|
|
|
|
|
|
SAP HANA database By Microsoft |
|
|
|
|
|
|
 SIS-CC SDMX By SIS-CC |
|
|
|
|
|
|
 SharePoint folder By Microsoft |
|
|
|
|
|
|
SharePoint list By Microsoft |
|
|
|
|
|
|
SharePoint Online list By Microsoft |
|
|
|
1 |
|
|
 Shortcuts Business Insights (Beta) By Shortcuts |
|
|
|
|
|
|
 SiteImprove By SiteImprove |
|
|
|
|
|
|
 Smartsheet By Microsoft |
|
|
|
|
|
|
Snowflake By Microsoft |
|
|
|
|
|
|
 SoftOneBI (Beta) By SoftOne |
|
|
|
|
|
|
 Solver By BI360 |
|
|
|
|
|
|
Spark By Microsoft |
|
|
|
|
|
|
 SparkPost (Beta) By Microsoft |
|
|
|
|
|
|
 Spigit (Beta) By Spigit |
|
|
|
|
|
|
 Starburst Enterprise (Beta) By Starburst Data |
|
|
|
|
|
|
SQL Server Analysis Services database By Microsoft |
|
|
|
|
|
|
SQL Server database By Microsoft |
|
|
|
|
|
|
 SumTotal (Beta) By SumTotal |
|
|
|
|
|
|
 SurveyMonkey (Beta) By SurveyMonkey |
|
|
|
|
|
|
 SweetIQ (Beta) By Microsoft |
|
|
|
|
|
|
Sybase Database By Microsoft |
|
|
|
|
|
|
1 Available in dataflows for Microsoft Teams.
T
| Connector | Excel | Power BI (Datasets) | Power BI (Dataflows) | 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 (Datasets) | Power BI (Dataflows) | Power Apps (Dataflows) | Customer Insights (Dataflows) |
Analysis Services |
|---|---|---|---|---|---|---|
 Usercube (Beta) By Usercube |
|
|
|
|
|
|
V
| Connector | Excel | Power BI (Datasets) | Power BI (Dataflows) | Power Apps (Dataflows) | Customer Insights (Dataflows) |
Analysis Services |
|---|---|---|---|---|---|---|
 Vena (Beta) By Vena |
|
|
|
|
|
|
 Vertica By Microsoft |
|
|
|
|
|
|
 Vessel Insight By Kongsberg |
|
|
|
|
|
|
W
| Connector | Excel | Power BI (Datasets) | Power BI (Dataflows) | Power Apps (Dataflows) | Customer Insights (Dataflows) |
Analysis Services |
|---|---|---|---|---|---|---|
 Web By Microsoft |
|
|
|
1 |
|
|
 Webtrends Analytics (Beta) By Microsoft |
|
|
|
|
|
|
 Witivio (Beta)By Witivio |
|
|
|
|
|
|
 Workforce Dimensions (Beta) (Deprecated) By Kronos |
|
|
|
|
|
|
 Workplace Analytics (Beta) By Microsoft |
|
|
|
|
|
|
1 Available in dataflows for Microsoft Teams.
X
| Connector | Excel | Power BI (Datasets) | Power BI (Dataflows) | Power Apps (Dataflows) | Customer Insights (Dataflows) |
Analysis Services |
|---|---|---|---|---|---|---|
 XML By Microsoft |
|
|
|
1 |
|
|
1 Available in dataflows for Microsoft Teams.
Z
| Connector | Excel | Power BI (Datasets) | Power BI (Dataflows) | Power Apps (Dataflows) | Customer Insights (Dataflows) |
Analysis Services |
|---|---|---|---|---|---|---|
 Zendesk (Beta) By Microsoft |
|
|
|
|
|
|
 Zoho Creator (Beta) By Zoho |
|
|
|
|
|
|
 Zucchetti HR Infinity (Beta) By Zucchetti |
|
|
|
|
|
|
Next steps
Feedback
Submit and view feedback for