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
  • Facebook
  • 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