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 By Microsoft	Yes	Yes	Yes
Acterys: Model Automation & Planning (Preview) By Acterys	No	Yes	Yes
Actian (Preview) By Actian	No	Yes	Yes
Active Directory By Microsoft	Yes	Yes	Yes
Adobe Analytics By Microsoft	No	Yes	Yes
ADP Analytics By ADP	No	Yes	Yes
Amazon Athena By Amazon	No	Yes	Yes
Amazon OpenSearch Service (Preview) By Amazon	No	Yes	Yes
Amazon Redshift By Microsoft	No	Yes	Yes
Anaplan By Anaplan	No	Yes	Yes
appFigures (Preview) By Microsoft	No	Yes	No
Asana By Asana	No	Yes	Yes
Assemble Views By Autodesk	No	Yes	Yes
AtScale cubes By Microsoft	No	Yes	Yes
Attio (Preview)	No	Yes	Yes
Autodesk Construction Cloud By Autodesk	No	Yes	Yes
Automation Anywhere By Automation Anywhere	No	Yes	Yes
Automy Data Analytics By AUTOMY	No	Yes	Yes
Azure Analysis Services database By Microsoft	No	Yes	Yes
Azure Blob Storage By Microsoft	Yes	Yes	Yes
Azure Cosmos DB By Microsoft	No	Yes	No
Azure Cosmos DB for MongoDB vCore (Preview) By Microsoft	No	Yes	Yes
Azure Cosmos DB v2 By Microsoft	No	Yes	Yes
Azure Cost Management By Microsoft	No	Yes	Yes
Azure Data Explorer (Kusto) (Preview) By Microsoft	Yes	Yes	Yes
Azure Data Lake Storage Gen1 By Microsoft	Yes	Yes	Yes
Azure Data Lake Storage Gen2 By Microsoft	No	Yes	Yes
Azure Database for MySQL	No	Yes	Yes
Azure Database for PostgreSQL By Microsoft	No	Yes	Yes
Azure Databricks By Databricks	No	Yes	Yes
Azure Device Registry (Preview) By Microsoft	No	Yes	Yes
Azure DevOps By Microsoft	No	Yes	No
Azure DevOps Server By Microsoft	No	Yes	No
Azure HDInsight (HDFS) By Microsoft	Yes	Yes	Yes
Azure HDInsight Spark By Microsoft	No	Yes	Yes
Azure HorizonDB Database	No	Yes	Yes
Azure Resource Graph By Microsoft	No	Yes	Yes
Azure SQL database By Microsoft	Yes	Yes	Yes
Azure Synapse Analytics (SQL DW) By Microsoft	Yes	Yes	Yes
Azure Synapse Analytics workspace (Preview) By Microsoft	No	Yes	Yes
Azure Table Storage By Microsoft	Yes	Yes	Yes

B

Connector	Excel	Power BI (semantic models)	Power Query Online
BI Connector By Guidanz	No	Yes	Yes
Bitbucket (Preview)	No	Yes	Yes
Bitly (Preview)	No	Yes	Yes
Bitsight Security Ratings By BitSight	No	Yes	Yes
Bloomberg Data and Analytics By Bloomberg	No	Yes	Yes
BQE Core By BQE	No	Yes	Yes
BuildingConnected (Preview) By Autodesk	No	Yes	Yes

C

Connector	Excel	Power BI (semantic models)	Power Query Online
CData Connect Cloud By CData	No	Yes	Yes
Celonis EMS By Celonis	No	Yes	Yes
Cherwell (Preview) By Cherwell	No	Yes	Yes
ClickHouse By ClickHouse, Inc.	No	Yes	Yes
CloudBluePSA (Preview) By CloudBlue PSA	No	Yes	Yes
Cognite Data Fusion (OData) By Cognite	No	Yes	Yes
Cognite Data Fusion (REST API) By Cognite	No	Yes	Yes
Common Data Service (Legacy) By Microsoft	No	Yes	Yes

D

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

E

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

F

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

G

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

H

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

I

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

J

Connector	Excel	Power BI (semantic models)	Power Query Online
Jamf Pro By Jamf	No	Yes	Yes
Jethro (Preview) By JethroData	No	Yes	Yes
JSON By Microsoft	Yes	Yes	Yes

K

Connector	Excel	Power BI (semantic models)	Power Query Online
Kognitwin By Kongsberg	No	Yes	Yes
KQL Database (Preview) By Microsoft	No	Yes	Yes
KX kdb Insights Enterprise Power Query (Preview) By KX Systems Inc.	No	Yes	Yes
Kyligence By Kyligence	No	Yes	Yes
Kyvos ODBC By Kyvos Insights	No	Yes	Yes

L

Connector	Excel	Power BI (semantic models)	Power Query Online
Lakehouse (Preview) By Microsoft	No	Yes	Yes
LEAP (Preview) By LEAP	No	Yes	Yes
Linkar PICK Style / MultiValue Databases (Preview) By Kosday Solutions	No	Yes	Yes
LinkedIn Learning - Power BI By LinkedIn	No	Yes	Yes
LinkedIn Sales Navigator (Preview) By Microsoft	No	Yes	No

M

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

O

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

P

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

Q

Connector	Excel	Power BI (semantic models)	Power Query Online
QubolePresto (Preview) By Qubole	No	Yes	Yes
Quickbase By Quick Base	No	Yes	Yes

R

Connector	Excel	Power BI (semantic models)	Power Query Online
R Script By Microsoft	No	Yes	No
Roamler (Preview) By Roamler	No	Yes	Yes

S

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

T

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

U

Connector	Excel	Power BI (semantic models)	Power Query Online
Usercube (Preview) By Usercube	No	Yes	Yes

V

Connector	Excel	Power BI (semantic models)	Power Query Online
Vena By Vena	No	Yes	Yes
Vertica database By Microsoft	No	Yes	Yes
Vessel Insight By Kongsberg	No	Yes	Yes
Viva Insights By Microsoft	No	Yes	Yes

W

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