Skip to Main Content
Excel Power Pivot & Power Query For Dummies, 2nd Edition
book

Excel Power Pivot & Power Query For Dummies, 2nd Edition

by Michael Alexander
March 2022
Beginner to intermediate content levelBeginner to intermediate
288 pages
7h 21m
English
For Dummies
Content preview from Excel Power Pivot & Power Query For Dummies, 2nd Edition

Chapter 9

Power Query Connection Types

IN THIS CHAPTER

check Extracting data from files

check Getting data from external databases

check Importing from other nonstandard data systems

check 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:

  • From File: Pulls data from specified Excel files, text files, CSV files, XML files, or folders
  • From Database: Pulls data from a database such as Microsoft Access, SQL Server, or SQL Server Analysis Services
  • From Azure: Pulls data from Microsoft’s Azure Cloud service
  • From PowerBI: Pulls data from PowerBI data sets made available ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365), 7th Edition

Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365), 7th Edition

Wayne Winston
Microsoft Excel 365 Bible

Microsoft Excel 365 Bible

Michael Alexander, Dick Kusleika
Excel 2019 Bible

Excel 2019 Bible

Michael Alexander, Richard Kusleika, John Walkenbach

Publisher Resources

ISBN: 9781119844488Purchase Link