Using the Power Query Add-In - Microsoft Business Intelligence Tools for Excel Analysts - page 140

➤ From Other Sources: Pulls data from a wide array of inter-company, cloud, and big data
sources. This category includes an option to start with a Blank Query in the event you want to
write your own M code from scratch.
➤ From Table: Pull data from a defined Excel table within the existing workbook.
Figure 7-15: Power Query has the ability to connect to a wide array of data sources, from simple text files to big
data sources such as Hadoop.
After you select a connection type you enter the parameters Power Query requires in a series of
dialog boxes. Such parameters Power Query needs to connect to a data source are file path, URL,
server name, and credentials.
Each connection type requires a unique set of parameters, so each of its dialog boxes will be different.
Luckily, Power Query rarely needs more than a handful of parameters to connect to any one data
source, so the dialog boxes are relatively intuitive and hassle-free.