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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2014 Chris Webb
About this chapter
Cite this chapter
Webb, C. (2014). Power Query Data Sources. In: Power Query for Power BI and Excel. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-6692-1_2
Download citation
DOI: https://doi.org/10.1007/978-1-4302-6692-1_2
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-6691-4
Online ISBN: 978-1-4302-6692-1
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)