Chapter 4: Connecting to Various Data Sources Using Get & Transform
In this chapter, you will learn how to connect to numerous data sources using the Get & Transform tool, known as Power Query, and investigate data source settings. There are a multitude of different ways in which you can connect various data and this chapter will deal with the data sources you can connect to, from a basic Excel file to multiple SQL servers, using both Excel and Power BI.
Throughout this chapter, we will learn about the connection procedures and the optimum data source to use.
In this chapter, we're going to cover the following topics:
- Connecting from a table or range
- Connecting from the web
- Connecting from a relational database
- Understanding custom connections
- Exploring data source settings