Chapter 2: Connecting to Fetch Data

One of the main aspects of Power Query is the wide range of data connectors. It offers a varied range of connection options and users can connect to data sources that reside on the cloud, on premises, and in local directories intuitively.

The idea is to treat all data sources at the same level and users (once they select the data they want to transform coming from different sources) can operate and combine them without caring about the data sources' original structure.

In this chapter, there will be an overview of connectors, and we will cover some of the best practices for how to connect to some of the most common connector types.

The recipes that will be covered in this chapter are the following:

  • Getting ...

Get Power Query Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.