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 data and connector navigation
- Creating a query from files
- Creating a query from a folder
- Creating a query from a database
- Creating a query from a website
