Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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 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 |
|
|
|
|
|
|
|
ADP Analytics By ADP |
|
|
|
|
|
|
|
Amazon Athena By Amazon |
|
|
|
|
|
|
|
Amazon OpenSearch Service (Beta) By Amazon |
|
|
|
|
|
|
|
Amazon Redshift By Microsoft |
|
|
|
|
|
|
|
Anaplan By Anaplan |
|
|
|
|
|
|
|
appFigures (Beta) By Microsoft |
|
|
|
|
|
|
|
Asana By Asana |
|
|
|
|
|
|
|
Assemble Views By Autodesk |
|
|
|
|
|
|
|
AtScale cubes By Microsoft |
|
|
|
|
|
|
|
Autodesk Construction Cloud By Autodesk |
|
|
|
|
|
|
|
Automation Anywhere By Automation Anywhere |
|
|
|
|
|
|
|
Automy Data Analytics By AUTOMY |
|
|
|
|
|
|
|
Azure Analysis Services database By Microsoft |
|
|
|
|
|
|
|
Azure Blob Storage By Microsoft |
|
|
|
|
|
|
|
Azure Cosmos DB By Microsoft |
|
|
|
|
|
|
|
|
Azure Cosmos DB for MongoDB vCore By Microsoft |
|
|
|
|
|
|
|
|
Azure Cosmos DB v2 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 Device Registry (Beta) By Microsoft |
|
|
|
|
|
|
|
Azure DevOps By Microsoft |
|
|
|
|
|
|
|
|
Azure DevOps Server By Microsoft |
|
|
|
|
|
|
|
Azure HDInsight (HDFS) 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 |
|
|
|
|
|
|
|