Connectors in Power Query

Find connectors alphabetically and select a name to view its reference documentation. Names without links don't have a reference article linked here.

This index lists connector availability for Excel, Power BI (semantic models), and Power Query Online (products hosted on the web, such as Dataflow Gen1 / Gen2 and others).

Important

Availability, authentication, gateway requirements, and destinations vary by host. Support in one host doesn't imply support in all others. Check the connector reference and your product's documentation.

Check the connector reference for its current release status and any retirement guidance.

The Excel column indicates availability in at least one Excel version, not every version. For version-specific support, see Power Query data sources in Excel versions. For Analysis Services availability, see the connector reference. For virtual network gateways, see Supported Azure data services.

Note

There's a known issue that results in an Expression.Error: The import [connector name] matches no exports error where connectors that require a gateway aren't working in dataflows in Premium workspaces. The product team is working on a fix and will update the documentation when a fix is released.

Note

Starting March 31, 2024, support for government cloud data sources by using an organizational account stops in non-governmental Power BI environments. To use government cloud data sources with an organizational account, use the government Power BI environment.

Browse connectors: A | B | C | D | E | F | G | H | I | J | K | L | M | O | P | Q | R | S | T | U | V | W | X | Z

A

Connector Excel Power BI (semantic models) Power Query Online
Access database connector icon. Access database Yes Yes Yes
Acterys: Model Automation & Planning connector icon. Acterys: Model Automation & Planning (Preview) No Yes Yes
Actian connector icon. Actian (Preview) No Yes Yes
Active Directory connector icon. Active Directory Yes Yes Yes
Adobe Analytics connector icon. Adobe Analytics No Yes Yes
ADP Analytics connector icon. ADP Analytics No Yes Yes
Amazon Athena connector icon. Amazon Athena No Yes Yes
Amazon OpenSearch Service connector icon. Amazon OpenSearch Service (Preview) No Yes Yes
Amazon Redshift connector icon. Amazon Redshift No Yes Yes
Anaplan connector icon. Anaplan No Yes Yes
appFigures connector icon. appFigures (Preview) No Yes No
Asana connector icon. Asana No Yes Yes
Assemble Views connector icon. Assemble Views No Yes Yes
AtScale cubes connector icon. AtScale cubes No Yes Yes
Attio (Preview) No Yes Yes
Autodesk Construction Cloud connector icon. Autodesk Construction Cloud No Yes Yes
Automation Anywhere connector icon. Automation Anywhere No Yes Yes
Automy Data Analytics connector icon. Automy Data Analytics No Yes Yes
Azure Analysis Services database connector icon. Azure Analysis Services database No Yes Yes
Azure Blob Storage connector icon. Azure Blob Storage Yes Yes Yes
Azure Cosmos DB connector icon. Azure Cosmos DB No Yes No
Azure Cosmos DB for MongoDB vCore connector icon. Azure Cosmos DB for MongoDB vCore (Preview) No Yes Yes
Azure Cosmos DB v2 connector icon. Azure Cosmos DB v2 No Yes Yes
Azure Cost Management connector icon. Azure Cost Management No Yes Yes
Azure Data Explorer (Kusto) connector icon. Azure Data Explorer (Kusto) (Preview) Yes Yes Yes
Azure Data Lake Storage Gen1 connector icon. Azure Data Lake Storage Gen1 Yes Yes Yes
Azure Data Lake Storage Gen2 connector icon. Azure Data Lake Storage Gen2 No Yes Yes
Azure Database for MySQL connector icon. Azure Database for MySQL No Yes Yes
Azure Database for PostgreSQL connector icon. Azure Database for PostgreSQL No Yes Yes
Azure Databricks connector icon. Azure Databricks No Yes Yes
Azure Device Registry connector icon. Azure Device Registry (Preview) No Yes Yes
Azure DevOps connector icon. Azure DevOps No Yes No
Azure DevOps Server connector icon. Azure DevOps Server No Yes No
Azure HDInsight (HDFS) connector icon. Azure HDInsight (HDFS) Yes Yes Yes
Azure HDInsight Spark connector icon. Azure HDInsight Spark No Yes Yes
Azure HorizonDB Database connector icon. Azure HorizonDB Database No Yes Yes
Azure Resource Graph connector icon. Azure Resource Graph No Yes Yes
Azure SQL database connector icon. Azure SQL database Yes Yes Yes
Azure Synapse Analytics (SQL DW) connector icon. Azure Synapse Analytics (SQL DW) Yes Yes Yes
Azure Synapse Analytics workspace connector icon. Azure Synapse Analytics workspace (Preview) No Yes Yes
Azure Table Storage connector icon. Azure Table Storage Yes Yes Yes

B

Connector Excel Power BI (semantic models) Power Query Online
BI Connector connector icon. BI Connector No Yes Yes
Bitbucket (Preview) No Yes Yes
Bitly (Preview) No Yes Yes
Bitsight Security Ratings connector icon. Bitsight Security Ratings No Yes Yes
Bloomberg Data and Analytics connector icon. Bloomberg Data and Analytics No Yes Yes
BQE Core connector icon. BQE Core No Yes Yes
BuildingConnected connector icon. BuildingConnected (Preview) No Yes Yes

C

Connector Excel Power BI (semantic models) Power Query Online
CData Connect Cloud connector icon. CData Connect Cloud No Yes Yes
Celonis EMS connector icon. Celonis EMS No Yes Yes
Cherwell connector icon. Cherwell (Preview) No Yes Yes
ClickHouse connector icon. ClickHouse No Yes Yes
CloudBluePSA connector icon. CloudBluePSA (Preview) No Yes Yes
Cognite Data Fusion (OData) connector icon. Cognite Data Fusion (OData) No Yes Yes
Cognite Data Fusion (REST API) connector icon. Cognite Data Fusion (REST API) No Yes Yes
Common Data Service (Legacy) connector icon. Common Data Service (Legacy) No Yes Yes

D

Connector Excel Power BI (semantic models) Power Query Online
Data Virtuality LDW connector icon. Data Virtuality LDW No Yes Yes
Data.World - Get Dataset connector icon. Data.World - Get Dataset (Preview) No Yes No
Databricks connector icon. Databricks No Yes Yes
Dataflows connector icon. Dataflows Yes Yes Yes
Dataverse connector icon. Dataverse Yes Yes Yes
Dataverse - Data Lake (Preview) No Yes Yes
Delta Sharing connector icon. Delta Sharing No Yes Yes
Denodo connector icon. Denodo No Yes Yes
Digital Construction Works Insights connector icon. Digital Construction Works Insights No Yes Yes
Dremio Cloud connector icon. Dremio Cloud No Yes Yes
Dremio Software connector icon. Dremio Software No Yes Yes
Dynamics 365 (Dataverse) connector icon. Dynamics 365 (Dataverse) No Yes Yes
Dynamics 365 Business Central connector icon. Dynamics 365 Business Central No Yes Yes
Dynamics 365 Business Central (on-premises) connector icon. Dynamics 365 Business Central (on-premises) No Yes No
Dynamics 365 Customer Insights connector icon. Dynamics 365 Customer Insights (Preview) No Yes Yes
Dynamics 365 Online (legacy) connector icon. Dynamics 365 Online (legacy) Yes Yes No
Dynamics NAV connector icon. Dynamics NAV No Yes No
Dynatrace Grail connector icon. Dynatrace Grail No Yes Yes

E

Connector Excel Power BI (semantic models) Power Query Online
Eduframe Reporting connector icon. Eduframe Reporting (Preview) No Yes Yes
ElasticSearch connector icon. ElasticSearch (Preview) No Yes Yes
Emigo Data Source connector icon. Emigo Data Source No Yes Yes
Entersoft Business Suite connector icon. Entersoft Business Suite (Preview) No Yes Yes
EQuIS connector icon. EQuIS No Yes Yes
Essbase connector icon. Essbase No Yes No
eWay-CRM connector icon. eWay-CRM No Yes Yes
Exact Online Premium connector icon. Exact Online Premium No Yes Yes
Exasol connector icon. Exasol No Yes Yes
Excel connector icon. Excel Yes Yes Yes

F

Connector Excel Power BI (semantic models) Power Query Online
Fabric SQL Analytics endpoint connector icon. Fabric SQL Analytics endpoint (Preview) No Yes Yes
FactSet connector icon. FactSet No Yes Yes
FHIR connector icon. FHIR No Yes Yes
Folder connector icon. Folder Yes Yes Yes
Funnel connector icon. Funnel No Yes Yes

G

Connector Excel Power BI (semantic models) Power Query Online
GitHub connector icon. GitHub (Preview) No Yes No
Google Analytics connector icon. Google Analytics No Yes Yes
Google BigQuery connector icon. Google BigQuery No Yes Yes
Google BigQuery (Microsoft Entra ID) connector icon. Google BigQuery (Microsoft Entra ID) No Yes Yes
Google Sheets connector icon. Google Sheets No Yes Yes

H

Connector Excel Power BI (semantic models) Power Query Online
Hadoop File (HDFS) connector icon. Hadoop File (HDFS) Yes Yes No
HDInsight Interactive Query connector icon. HDInsight Interactive Query No Yes Yes
Hexagon PPM Smart API connector icon. Hexagon PPM Smart API No Yes Yes
Hive LLAP connector icon. Hive LLAP No Yes Yes

I

Connector Excel Power BI (semantic models) Power Query Online
IBM Db2 database connector icon. IBM Db2 database Yes Yes Yes
IBM Informix database connector icon. IBM Informix database (Preview) No Yes No
IBM Netezza database connector icon. IBM Netezza database No Yes Yes
Impala database connector icon. Impala database No Yes Yes
Indexima connector icon. Indexima No Yes Yes
Industrial App Store connector icon. Industrial App Store No Yes Yes
InformationGrid connector icon. InformationGrid No Yes Yes
Intersystems Health Insight connector icon. Intersystems Health Insight No Yes Yes
Intune Data Warehouse connector icon. Intune Data Warehouse (Retired) No No No
Intune Data Warehouse v2 connector icon. Intune Data Warehouse (v2) (Preview) No Yes Yes
inwink connector icon. inwink (Preview) No Yes Yes

J

Connector Excel Power BI (semantic models) Power Query Online
Jamf Pro connector icon. Jamf Pro No Yes Yes
Jethro connector icon. Jethro (Preview) No Yes Yes
JSON connector icon. JSON Yes Yes Yes

K

Connector Excel Power BI (semantic models) Power Query Online
Kognitwin connector icon. Kognitwin No Yes Yes
KQL Database connector icon. KQL Database (Preview) No Yes Yes
KX kdb Insights Enterprise Power Query connector icon. KX kdb Insights Enterprise Power Query (Preview) No Yes Yes
Kyligence connector icon. Kyligence No Yes Yes
Kyvos ODBC connector icon. Kyvos ODBC No Yes Yes

L

Connector Excel Power BI (semantic models) Power Query Online
Lakehouse connector icon. Lakehouse (Preview) No Yes Yes
LEAP connector icon. LEAP (Preview) No Yes Yes
Linkar PICK Style / MultiValue Databases connector icon. Linkar PICK Style / MultiValue Databases (Preview) No Yes Yes
LinkedIn Learning - Power BI connector icon. LinkedIn Learning - Power BI No Yes Yes
LinkedIn Sales Navigator connector icon. LinkedIn Sales Navigator (Preview) No Yes No

M

Connector Excel Power BI (semantic models) Power Query Online
MariaDB connector icon. MariaDB No Yes Yes
Marketo connector icon. Marketo (Preview) No Yes No
MarkLogic connector icon. MarkLogic No Yes Yes
Microsoft Azure Data Manager for Energy connector icon. Microsoft Azure Data Manager for Energy (Preview) No Yes Yes
Microsoft Exchange connector icon. Microsoft Exchange Yes Yes No
Microsoft Exchange Online connector icon. Microsoft Exchange Online Yes Yes Yes
Microsoft Sentinel connector icon. Microsoft Sentinel (Preview) No Yes Yes
MicroStrategy for Power BI connector icon. MicroStrategy for Power BI No Yes Yes
Mixpanel connector icon. Mixpanel (Preview) No Yes No
MongoDB Atlas SQL interface connector icon. MongoDB Atlas SQL interface No Yes Yes
MySQL database connector icon. MySQL database Yes Yes Yes

O

Connector Excel Power BI (semantic models) Power Query Online
OData Feed connector icon. OData Feed Yes Yes Yes
ODBC connector icon. ODBC Yes Yes Yes
OLE DB connector icon. OLE DB Yes Yes No
OneLake Files connector icon. OneLake Files (Preview) No Yes Yes
OneStream connector icon. OneStream No Yes Yes
OpenSearch Project connector icon. OpenSearch Project (Preview) No Yes Yes
Oracle database connector icon. Oracle database Yes Yes Yes

P

Connector Excel Power BI (semantic models) Power Query Online
Palantir Foundry connector icon. Palantir Foundry No Yes Yes
Parquet connector icon. Parquet No Yes Yes
Paxata connector icon. Paxata No Yes Yes
PDF connector icon. PDF Yes Yes Yes
Planview Enterprise Architecture connector icon. Planview Enterprise Architecture No Yes Yes
Planview IdeaPlace connector icon. Planview IdeaPlace No Yes Yes
Planview OKR connector icon. Planview OKR (Preview) No Yes Yes
Planview Portfolios connector icon. Planview Portfolios No Yes Yes
Planview ProjectPlace connector icon. Planview ProjectPlace No Yes Yes
PostgreSQL connector icon. PostgreSQL Yes Yes Yes
Power BI dataflows (Legacy) No Yes Yes
Power BI semantic models connector icon. Power BI semantic models Yes Yes No
Product Insights connector icon. Product Insights (Preview) No Yes Yes
Profisee connector icon. Profisee No Yes Yes
Python Script connector icon. Python Script No Yes No

Q

Connector Excel Power BI (semantic models) Power Query Online
QubolePresto connector icon. QubolePresto (Preview) No Yes Yes
Quickbase connector icon. Quickbase No Yes Yes

R

Connector Excel Power BI (semantic models) Power Query Online
R Script connector icon. R Script No Yes No
Roamler connector icon. Roamler (Preview) No Yes Yes

S

Connector Excel Power BI (semantic models) Power Query Online
Salesforce Objects connector icon. Salesforce Objects Yes Yes Yes
Salesforce Reports connector icon. Salesforce Reports Yes Yes Yes
Samsara connector icon. Samsara No Yes Yes
SAP Business Warehouse Application Server connector icon. SAP Business Warehouse Application Server No Yes Yes
SAP Business Warehouse Message Server connector icon. SAP Business Warehouse Message Server No Yes Yes
SAP HANA database connector icon. SAP HANA database Yes Yes Yes
SharePoint folder connector icon. SharePoint folder Yes Yes Yes
SharePoint list connector icon. SharePoint list Yes Yes Yes
SharePoint Online list connector icon. SharePoint Online list Yes Yes Yes
Shortcuts Business Insights connector icon. Shortcuts Business Insights (Preview) No Yes Yes
SingleStore connector icon. SingleStore No Yes Yes
SIS-CC SDMX connector icon. SIS-CC SDMX (Preview) No Yes Yes
Siteimprove connector icon. Siteimprove No Yes Yes
Smartsheet connector icon. Smartsheet No Yes Yes
Snowflake connector icon. Snowflake No Yes Yes
SoftOne BI connector icon. SoftOne BI (Preview) No Yes Yes
SolarWinds Service Desk connector icon. SolarWinds Service Desk No Yes Yes
Solver connector icon. Solver No Yes Yes
Spark and Azure HDInsight Spark connector icon. Spark and Azure HDInsight Spark No Yes Yes
SparkPost connector icon. SparkPost (Preview) No Yes No
SQL database in Fabric connector icon. SQL database in Fabric (Preview) No Yes Yes
SQL Server connector icon. SQL Server Yes Yes Yes
SQL Server Analysis Services database connector icon. SQL Server Analysis Services database Yes Yes Yes
Starburst connector icon. Starburst No Yes Yes
Starburst secured by Entra ID connector icon. Starburst secured by Entra ID No Yes Yes
SumTotal connector icon. SumTotal No Yes Yes
Supermetrics connector icon. Supermetrics (Preview) No Yes Yes
SurveyMonkey connector icon. SurveyMonkey No Yes Yes
SweetIQ connector icon. SweetIQ (Preview) No Yes No
Sybase database connector icon. Sybase database Yes Yes Yes

T

Connector Excel Power BI (semantic models) Power Query Online
TeamDesk connector icon. TeamDesk (Preview) No Yes Yes
Tenforce (Smart)List connector icon. Tenforce (Smart)List No Yes Yes
Teradata database connector icon. Teradata database Yes Yes Yes
Text/CSV connector icon. Text/CSV Yes Yes Yes
TIBCO(R) Data Virtualization connector icon. TIBCO(R) Data Virtualization No Yes Yes
Topcon Aptix Insights connector icon. Topcon Aptix Insights No Yes Yes

U

Connector Excel Power BI (semantic models) Power Query Online
Usercube connector icon. Usercube (Preview) No Yes Yes

V

Connector Excel Power BI (semantic models) Power Query Online
Vena connector icon. Vena No Yes Yes
Vertica database connector icon. Vertica database No Yes Yes
Vessel Insight connector icon. Vessel Insight No Yes Yes
Viva Insights connector icon. Viva Insights No Yes Yes

W

Connector Excel Power BI (semantic models) Power Query Online
Warehouse connector icon. Warehouse (Preview) No Yes Yes
Web connector icon. Web Yes Yes Yes
Webtrends Analytics connector icon. Webtrends Analytics (Preview) No Yes Yes
Windsor connector icon. Windsor No Yes Yes
Witivio connector icon. Witivio (Preview) No Yes Yes
Wolters Kluwer CCH Tagetik connector icon. Wolters Kluwer CCH Tagetik No Yes Yes
Wrike connector icon. Wrike (Preview) No Yes Yes

X

Connector Excel Power BI (semantic models) Power Query Online
XML connector icon. XML Yes Yes Yes

Z

Connector Excel Power BI (semantic models) Power Query Online
Zendesk Data connector icon. Zendesk Data (Preview) No Yes Yes
Zoho Creator connector icon. Zoho Creator No Yes Yes
Zucchetti HR Infinity connector icon. Zucchetti HR Infinity (Preview) No Yes Yes
  • تاريخ آخر تحديث في