Power Query Connectors

Data Connectors for Power Query in Excel
One of the things that makes Power Query so powerful is able to connect to almost any type of data source. So how come you find yourself asking, "Why is this connector not available to me?" Well, it very likely has to do with what SKU (or version) of Excel you are running.

Many of the data connectors are available in all versions of Excel, but some are available only in "professional" editions. These SKUs include:

  • Office 365 ProPlus
  • Office 2016 Professional
  • Office 2016 Professional Plus, and
  • Excel 2016 standalone

It is also important to note that new connectors and other updates that Microsoft release for Power Query are only made available to subscription-based SKUs of Office; they are not available in non-subscriptions (standalone) versions. To find out what SKU of Office you are running, go to File --> About, and it will be identified at the top of the Product Information window that appears.

More information on Power Query in Excel is available in this article from Microsoft.

For a quick overview of the various connectors and their availability, please see the chart below:

Data Type Connections All Versions Pro Versions Only
From File
Excel Workbook
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
CSV & Text
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
XML
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
JSON
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
Folder
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
SharePoint Folder
Name:  X-mark_Red_15x15.png
Views: 1410
Size:  508 Bytes Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
From Database
SQL Server
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
Access
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
Analysis Services
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
SQL Server Analysis Services Database (Import)
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
Oracle
Name:  X-mark_Red_15x15.png
Views: 1410
Size:  508 Bytes
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
IBM DB2
Name:  X-mark_Red_15x15.png
Views: 1410
Size:  508 Bytes
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
MySQL
Name:  X-mark_Red_15x15.png
Views: 1410
Size:  508 Bytes
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
PostgreSQL
Name:  X-mark_Red_15x15.png
Views: 1410
Size:  508 Bytes
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
Sybase
Name:  X-mark_Red_15x15.png
Views: 1410
Size:  508 Bytes
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
Teradata
Name:  X-mark_Red_15x15.png
Views: 1410
Size:  508 Bytes
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
SAP Hana
Name:  X-mark_Red_15x15.png
Views: 1410
Size:  508 Bytes Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
From Azure
Azure SQL Server
Name:  X-mark_Red_15x15.png
Views: 1410
Size:  508 Bytes
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
Azure SQL Data Warehouse
Name:  X-mark_Red_15x15.png
Views: 1410
Size:  508 Bytes
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
Azure HDInsight (HDFS)
Name:  X-mark_Red_15x15.png
Views: 1410
Size:  508 Bytes
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
Azure Blob Storage
Name:  X-mark_Red_15x15.png
Views: 1410
Size:  508 Bytes
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
Azure Table
Name:  X-mark_Red_15x15.png
Views: 1410
Size:  508 Bytes
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
Azure Data Lake Storage
Name:  X-mark_Red_15x15.png
Views: 1410
Size:  508 Bytes
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
From Online Sources
SharePoint Online List
Name:  X-mark_Red_15x15.png
Views: 1410
Size:  508 Bytes
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
Microsoft Exchange
Name:  X-mark_Red_15x15.png
Views: 1410
Size:  508 Bytes
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
Dynamics CRM
Name:  X-mark_Red_15x15.png
Views: 1410
Size:  508 Bytes
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
Facebook
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
Salesforce Objects
Name:  X-mark_Red_15x15.png
Views: 1410
Size:  508 Bytes
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
Salesforce Reports
Name:  X-mark_Red_15x15.png
Views: 1410
Size:  508 Bytes Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
Other Sources
Table/Range
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
Web
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
Microsoft Query
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
SharePoint List
Name:  X-mark_Red_15x15.png
Views: 1410
Size:  508 Bytes
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
OData Feed
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
Hadoop
Name:  X-mark_Red_15x15.png
Views: 1410
Size:  508 Bytes
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
Active Directory
Name:  X-mark_Red_15x15.png
Views: 1410
Size:  508 Bytes
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
Microsoft Exchange
Name:  X-mark_Red_15x15.png
Views: 1410
Size:  508 Bytes
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
ODBC
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
OLEDB
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes
Blank Query
Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes Name:  CheckMark_Green_15x15.png
Views: 1411
Size:  569 Bytes

Share:

Facebook
Twitter
LinkedIn

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Latest Posts

Excel Fundamentals Boot Camp

COACHED TRAINING: Excel Fundamentals Boot Camp Course Description In the Fundamentals Boot Camp, you will begin with a review core skills for the Excel analyst. This section is geared to

Read More »