Power Query: Supported Data Sources
This is a simple list to easily find what data sources are currently supported in Power Query. It will need to be maintained as this list changes.
Supported data sources for Power Query (as of the 3/5/14 release) in alphabetical order:
- Access database
- Active Directory
- CSV file
- Excel spreadsheets
- Folder
- Hadoop Distributed File System (HDFS)
- IBM DB2 database
- MySQL database
- OData feeds
- Oracle database
- SharePoint List
- SQL Server database
- Text files
- Web pages
- Windows Azure Marketplace
- Windows Azure SQL Database
- XML files
Other compatibility:
- Azure HDInsight
- JSON
- Relational databases
References
- Download Microsoft Power Query for Excel (Microsoft Download Center)
- Introduction to Microsoft Power Query for Excel (Office Support)