Power Query Data Sources

  • Chris Webb
Chapter

Abstract

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.

Keywords

Europe 

Copyright information

© Chris Webb 2014

Authors and Affiliations

  • Chris Webb
    • 1
  1. 1.BucksUnited Kingdom

Personalised recommendations