March 2022
Beginner to intermediate
288 pages
7h 21m
English
Chapter 9
IN THIS CHAPTER
Extracting data from files
Getting data from external databases
Importing from other nonstandard data systems
Understanding the Data Profiling feature
Microsoft has invested a great deal of time and resources in ensuring that Power Query has the ability to connect to a wide array of data sources. Whether you need to pull data from an external website, a text file, a database system, Facebook, or a web service, Power Query can accommodate most, if not all, of your source data needs.
You can see all available connection types by clicking on the Get Data drop-down arrow on the Data tab of the Excel Ribbon. Power Query offers the ability to pull from a wide array of data sources, as described in this list: