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.

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

Connector Excel        Power BI (Datasets) Power BI (Dataflows) Power Apps (Dataflows) Customer
Insights (Dataflows)
Analysis Services
Access Database connector
Access Database

By Microsoft
Yes Yes Yes Yes Yes Yes
Active Directory connector
Active Directory
By Microsoft
Yes Yes Yes No Yes Yes
Adobe Analytics connector
Adobe Analytics

By Microsoft
No Yes No No No No
Amazon Redshift connector
Amazon Redshift
By Microsoft
No Yes Yes Yes Yes No
appFigures (Beta)
appFigures
(Beta)

By Microsoft
No Yes No No No No
Asana (Beta)
Asana
By Asana
No Yes No No No No
AtScale cubes (Beta)
AtScale cubes
(Beta)

By Microsoft
No Yes No No No No
Azure Analysis Services database
Azure Analysis
Services database

By Microsoft
No Yes No No No No
Azure Blob Storage
Azure Blob
Storage

By Microsoft
Yes Yes Yes No Yes Yes
Azure Cosmos DB (Beta)
Azure CosmosDB
(Beta)

By Microsoft
No Yes No No No Yes
Azure Cost Management
Azure Cost
Management

By Microsoft
No Yes No No No No
Azure Data Explorer (Beta)
Azure Data
Explorer
(Beta)

By Microsoft
Yes Yes Yes Yes No No
Azure Data Lake Storage Gen1
Azure Data Lake
Storage Gen1

By Microsoft
Yes Yes No No No Yes
Azure Data Lake Storage Gen2 (Beta)
Azure Data Lake
Storage Gen2
(Beta)

By Microsoft
No Yes Yes Yes Yes Yes
Azure DevOps (Beta)
Azure DevOps
(Beta)

By Microsoft
No Yes No No No No
Azure DevOps Server (Beta)
Azure DevOps
Server
(Beta)

By Microsoft
No Yes No No No No
Azure HDInsight (HDFS)
Azure HDInsight
(HDFS)

By Microsoft
Yes Yes No No No Yes
Azure HDInsight Spark
Azure HDInsight
Spark

By Microsoft
No Yes Yes Yes Yes Yes
Azure SQL Data Warehouse
Azure SQL Data
Warehouse

By Microsoft
Yes Yes Yes Yes Yes Yes
Azure SQL database
Azure SQL
database

By Microsoft
Yes Yes Yes Yes Yes Yes
Azure Table Storage
Azure Table
Storage

By Microsoft
Yes Yes Yes No Yes Yes
Azure Time Series Insights (Beta)
Azure Time
Series Insights
(Beta)

By Microsoft
No Yes No No No No
BI Connector
BI Connector
By Guidanz
No Yes No No No No
BI360
BI360
By Solver Global
No Yes No No No No
Cognite Data Fusion (Beta)
Cognite Data
Fustion
(Beta)

By Cognite
No Yes No No No No
Common Data Service
Common Data
Service

By Microsoft
No Yes Yes No Yes No
Data.World - Get Dataset (Beta)
Data.World -
Get Dataset
(Beta)

By Microsoft
No Yes No No No No
Data Virtuality (Beta)
Data Virtuality
(Beta)

By Data Virtuality
No Yes No No No No
Denodo
Denodo
By Denodo
No Yes No No No No
Dremio (Beta)
Dremio
By Dremio
No Yes No No No No
Dynamics 365 (online)
Dynamics 365
(online)

By Microsoft
Yes Yes No No No Yes
Dynamics 365 Business Central
Dynamics 365
Business Central

By Microsoft
No Yes No No No No
Dynamics 365 Business Central (on-premises)
Dynamics 365
Business Central
(on-premises)

By Microsoft
No Yes No No No No
Dynamics 365 Customer Insights (Beta)
Dynamics 365
Customer Insights
(Beta)

By Microsoft
No Yes No No No No
Dynamics NAV
Dynamics NAV
By Microsoft
No Yes No No No No
Emigo Data Source
Emigo Data
Source

By Sagra
No Yes No No No No
Entersoft Business Suite (Beta)
Entersoft
Business Suite
(Beta)

By Entersoft
No Yes No No No No
Essbase
Essbase
By Microsoft
No Yes No No No No
Exasol
Exasol
By Exasol
No Yes No No No No
Excel
Excel

By Microsoft
Yes Yes Yes Yes Yes Yes
Facebook
Facebook

By Microsoft
No Yes No No No No
FactSet Analytics (Beta)
FactSet Analytics
(Beta)

By FactSet
No Yes No No No No
FHIR
FHIR

By Microsoft
No Yes No No No No
Folder
Folder

By Microsoft
Yes Yes Yes Yes Yes Yes
Github (Beta)
Github
(Beta)

By Microsoft
No Yes No No No No
Google Analytics
Google Analytics

By Microsoft
No Yes No No No No
Google BigQuery
Google BigQuery
By Microsoft
No Yes Yes Yes Yes No
Hadoop File (HDFS)
Hadoop File
(HDFS)

By Microsoft
Yes Yes No No No No
HDInsight Interactive Query
HDInsight
Interactive Query

By Microsoft
No Yes No No No No
Hive LLAP (Beta)
Hive LLAP (Beta)
By Microsoft
No Yes No No No No
IBM DB2 database
IBM DB2
database

By Microsoft
Yes Yes Yes Yes Yes No
IBM Informix database (Beta)
IBM Informix
database
(Beta)

By Microsoft
No Yes No No No Yes
IBM Netezza
IBM Netezza
By Microsoft
No Yes No No No No
Impala
Impala
By Microsoft
No Yes No Yes Yes No
Indexima (Beta)
Indexima (Beta)
By Indexima
No Yes No No No No
Industrial App Store
Industrial
App Store

By Intelligent Plant
No Yes No No No No
Information Grid (Beta)
Information
Grid (Beta)

By Luminis
No Yes No No No No
InterSystems IRIS (Beta)
InterSystems
IRIS (Beta)

By Intersystems
No Yes No No No No
Intune Data Warehouse (Beta)
Intune Data
Warehouse (Beta)

By Microsoft
No Yes No No No No
Jamf Pro (Beta)
Jamf Pro
(Beta)

By Jamf
No Yes No No No No
Jethro (Beta)
Jethro
(Beta)

By JethroData
No Yes No No No No
JSON
JSON

By Microsoft
Yes Yes Yes Yes Yes Yes
Kyligence
Kyligence
By Kyligence
No Yes No No No No
Linkar PICK Style/MultiValue Databases (Beta)
Linkar PICK Style/MultiValue Databases (Beta)
By Kosday Solutions
No Yes No No No No
LinkedIn Sales Navigator (Beta)
LinkedIn Sales Navigator (Beta)
By Microsoft
No Yes No No No No
Marketo (Beta)
Marketo
(Beta)

By Microsoft
No Yes No No No No
MarkLogic (Beta)
MarkLogic
(Beta)

By MarkLogic
No Yes No No No No
Microsoft Azure Consumption Insights (Beta)
Microsoft Azure
Consumption Insights
(Beta)

By Microsoft
No Yes No No No No
Microsoft Exchange
Microsoft Exchange
By Microsoft
Yes Yes No No No Yes
Microsoft Exchange Online
Microsoft Exchange
Online

By Microsoft
Yes Yes Yes No Yes No
Microsoft Graph Security (Beta)
Microsot Graph
Security (Beta)

By Microsoft
No Yes No No No No
MicroStrategy for Power BI
MicroStrategy
for Power BI

By MicroStrategy
No Yes No No No No
Mixpanel (Beta)
Mixpanel (Beta)
By Microsoft
No Yes No No No No
MySQL database
MySQL database

By Microsoft
Yes Yes Yes Yes Yes Yes
OData Feed
OData Feed

By Microsoft
Yes Yes Yes Yes Yes Yes
ODBC
ODBC

By Microsoft
Yes Yes Yes Yes Yes Yes
OLE DB
OLE DB
By Microsoft
Yes Yes No No No Yes
Oracle database
Oracle database
By Microsoft
Yes Yes Yes Yes Yes Yes
Parquet
Parquet
By Microsoft
No No No Yes No No
Palantir Foundry
Palantir Foundry
By Palantir
No Yes No No No No
Paxata
Paxata
By Paxata
No Yes No No No No
PDF
PDF
By Microsoft
Yes Yes Yes Yes Yes No
Planview Enterprise One - CTM (Beta)
Planview Enterprise
One - CTM (Beta)

By Planview
No Yes No No No No
Planview Enterprise One - PRM (Beta)
Planview Enterprise
One - PRM (Beta)

By Planview
No Yes No No No No
PostgreSQL database
PostgreSQL
database

By Microsoft
Yes Yes Yes Yes Yes Yes
Power BI dataflows (Beta)
Power BI dataflows
(Beta)

By Microsoft
No Yes No No No No
Power BI datasets
Power BI datasets
By Microsoft
No Yes No No No No
Power Platform dataflows
Power Platform
dataflows

By Microsoft
No Yes No Yes No No
Product Insights (Beta)
Product Insights
(Beta)

By Microsoft
No Yes No No No No
Projectplace for Power BI(Beta)
Projectplace
for Power BI
(Beta)

By Planview
No Yes No No No No
Python Script
Python Script
By Microsoft
No Yes No No No No
QubolePresto (Beta)
QubolePresto Beta
By Qubole
No Yes No No No No
Quickbooks Online (Beta)
Quickbooks Online
(Beta)

By Microsoft
No Yes No No No No
Quick Base
Quick Base
By Quick Base
No Yes No No No No
R Script
R Script
By Microsoft
No Yes No No No No
Roamler (Beta)
Roamler (Beta)
By Roamler
No Yes No No No No
Salesforce Objects
Salesforce Objects

By Microsoft
Yes Yes Yes Yes Yes Yes
Salesforce Reports
Salesforce Reports

By Microsoft
Yes Yes Yes Yes Yes Yes
SAP Business Warehouse Application Server
SAP Business
Warehouse
Application Server

By Microsoft
No Yes Yes Yes No Yes
SAP Business Warehouse Message Server
SAP Business
Warehouse
Message Server

By Microsoft
No Yes Yes Yes No No
SAP HANA database
SAP HANA
database

By Microsoft
Yes Yes Yes Yes No Yes
SharePoint Folder
SharePoint Folder

By Microsoft
Yes Yes Yes Yes Yes No
SharePoint list
SharePoint list

By Microsoft
Yes Yes Yes Yes Yes Yes
SharePoint Online List
SharePoint Online
List

By Microsoft
Yes Yes Yes Yes Yes No
Shortcuts Business Insights (Beta)
Shortcuts Business Insights (Beta)
By Shortcuts
No Yes No No No No
SiteImprove
SiteImprove
By SiteImprove
No Yes No No No No
Smartsheet
Smartsheet
By Microsoft
No Yes Yes No No No
Snowflake
Snowflake
By Microsoft
No Yes No Yes No No
Solver
Solver
By BI360
No Yes No No No No
Spark
Spark
By Microsoft
No Yes Yes Yes Yes No
SparkPost (Beta)
SparkPost (Beta)
By Microsoft
No Yes No No No No
SQL Server Analysis Services database
SQL Server Analysis
Services database

By Microsoft
Yes Yes No No No No
SQL Server database
SQL Server
database

By Microsoft
Yes Yes Yes Yes Yes Yes
SurveyMonkey (Beta)
SurveyMonkey (Beta)
By SurveyMonkey
No Yes No No No No
SweetIQ (Beta)
SweetIQ (Beta)
By Microsoft
No Yes No No No No
Sybase Database
Sybase Database
By Microsoft
Yes Yes Yes No Yes Yes
TeamDesk (Beta)
TeamDesk (Beta)
By ForeSoft
No Yes No No No No
Tenforce (Smart)List
Tenforce (Smart)List
By Tenforce
No Yes No No No No
Teradata database
Teradata database
By Microsoft
Yes Yes Yes Yes Yes Yes
Text/CSV
Text/CSV

By Microsoft
Yes Yes Yes Yes Yes Yes
TIBCO(R) Data Virtualization (Beta)
TIBCO(R) Data
Virtualization
(Beta)

By TIBCO
No Yes No No No No
Twilio (Beta)
Twilio (Beta)
By Microsoft
No Yes No No No No
Vena (Beta)
Vena (Beta)
By Vena
No Yes No No No No
Vertica
Vertica
By Microsoft
No Yes Yes No Yes No
Vessel Insights (Beta)
Vessel Insights (Beta)
By Kongsberg
No Yes No No No No
Web
Web

By Microsoft
Yes Yes Yes Yes Yes No
Webtrends Analytics(Beta)
Webtrends Analytics (Beta)
By Microsoft
No Yes No No No No
Witivio (Beta)
Witivio (Beta)
By Witivio
No Yes No No No No
Workforce Dimensions (Beta)
Workforce Dimensions
(Beta)

By Kronos
No Yes No No No No
Workplace Analytics (Beta)
Workplace Analytics
(Beta)

By Microsoft
No Yes No No No No
XML
XML

By Microsoft
Yes Yes Yes Yes Yes Yes
Zendesk (Beta)
Zendesk (Beta)
By Microsoft
No Yes No No No No
Zoho Creator (Beta)
Zoho Creater (Beta)
By Zoho
No Yes No No No No
Zucchetti HR Infinity (Beta)
Zucchetti HR
Infinity (Beta)

By Zucchetti
No Yes No No No No

Next steps