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 4

Using External Data with Power Pivot

IN THIS CHAPTER

check Importing from relational databases

check Importing from flat files

check Importing data from other data sources

check Refreshing and managing external data connections

In Chapter 2, I start an exploration of Power Pivot by showing you how to load the data already contained within the workbook you’re working on. But as you discover in this chapter, you’re not limited to using only the data that already exists in your Excel workbook.

Power Pivot has the ability to reach outside the workbook and import data found in external data sources. Indeed, what makes Power Pivot powerful is its ability to consolidate data from disparate data sources and build relationships between them. You can theoretically create a Power Pivot data model that contains some data from a SQL Server table, some data from a Microsoft Access database, and even data from a one-off text file.

In this chapter, I help you continue your journey by taking a closer look at the mechanics of importing external data into your Power Pivot data models.

This chapter has no associated ...

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