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 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 (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 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 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 |
|
|
|
|
|
|
 BitSight Security Ratings (Beta) By BitSight |
|
|
|
|
|
|
 Bloomberg Data and Analytics By Bloomberg |
|
|
|
|
|
|
 BQE Core 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 Fusion 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 LDW By Data Virtuality |
|
|
|
|
|
|
Databricks (Beta) By Databricks |
|
|
|
|
|
|
 Dataflows By Microsoft |
|
|
|
|
|
|
 Dataverse By Microsoft |
|
|
|
|
|
|
 Delta Sharing By Databricks |
|
|
|
|
|
|
 Denodo By Denodo |
|
|
|
|
|
|
 Digital Construction Works Insights (Beta) By Digital Construction Works |
|
|
|
|
|
|
 Dremio Cloud By Dremio |
|
|
|
|
|
|
Dremio Software 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 365 (Dataverse) By Microsoft |
|
|
|
|
|
|
Dynamics 365 Online (legacy) 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 |
|
|
|
|
|
|
 Eduframe Reporting (Beta) By Drieam |
|
|
|
|
|
|
 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 |
|
|
|
|
|
|
 FactSet RMS (Beta) By FactSet |
|
|
|
|
|
|
 FHIR By Microsoft |
|
|
|
|
|
|
 Folder By Microsoft |
|
|
|
|
|
|
 Funnel (Beta) By Funnel |
|
|
|
|
|
|
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 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 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 |
|
|
|
|
|
|
 Microsoft Teams Personal Analytics (Beta) 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 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 |
|
|
|
|
|
|
 Quickbase 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 |
|
|
|
|
|
|
 SingleStore (Beta) By SingleStore |
|
|
|
|
|
|
 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 By Starburst Data |
|
|
|
|
|
|
SQL Server Analysis Services database By Microsoft |
|
|
|
|
|
|
SQL Server database By Microsoft |
|
|
|
|
|
|
 SumTotal 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 By Vena |
|
|
|
|
|
|
 Vertica By Microsoft |
|
|
|
|
|
|
 Vessel Insight By Kongsberg |
|
|
|
|
|
|
 Viva Insights By Microsoft |
|
|
|
|
|
|
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 |
|
|
|
|
|
|
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 By Zoho |
|
|
|
|
|
|
 Zucchetti HR Infinity (Beta) By Zucchetti |
|
|
|
|
|
|
Next steps
Feedback
Submit and view feedback for