Power Query Data Sources

  • Chris Webb


One of the best things about Power Query is the wide range of data sources that it supports. In addition to the obvious types of data source, such as relational databases and text files, it supports more exotic sources including Facebook, Active Directory, and OData, which are becoming more and more important in self-service BI scenarios. This chapter will deal with that all-important first step when creating a Power Query query—making a connection to a data source and extracting the raw data you want to work with. It will provide a guided tour of all of the data sources supported by Power Query, and it will also discuss related topics such as authentication.


Relational Database Hadoop Distribute File System Window Azure Public Data Source Excel Workbook 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© Chris Webb 2014

Authors and Affiliations

  • Chris Webb
    • 1
  1. 1.BucksUnited Kingdom

Personalised recommendations