CHAPTER 3 Assem b ling DAtA
The primary way of bringing data into
your PowerPivot application is by importing it.
PowerPivot for Excel includes a tool for doing
this called the Table Import Wizard. The Table
Import Wizard is started from the Get External
Data section of the Home tab of the ribbon in
the PowerPivot Window. Figure 3-1 shows this
section of the PowerPivot ribbon.
As you can see, there are multiple drop-downs and buttons corresponding to the multiple data
source types that PowerPivot supports:
The From Database drop-down enables you to import data from various Microsoft database
types — SQL Server, Access, and Analysis Services/PowerPivot.
The From Report button enables you to import data from Microsoft SQL Server 2008 R2
and later Reporting Services reports.
The From Data Feeds button helps you to import data from data feeds (a new technology for
making available updatable data sources that will be described later in this chapter).
The From Text button enables you to import data from text ﬁles.
The From Other Sources button enables you to import data from every type of data source
that PowerPivot supports, including those that aren’t available from the other buttons.
The following sections describe the different types of data sources from which you can import data
In Chapter 2, you learned about importing data from Microsoft SQL Server. But, using PowerPivot,
you can import data from a variety of different relational databases in addition to Microsoft SQL
Server. Figure 3-2 shows a list of the supported relational data sources from PowerPivot’s Table
You can see that, in addition to Microsoft SQL Server, PowerPivot supports importing data from the
Microsoft SQL Azure
— This is a cloud-based relational database service built on Microsoft
SQL Server technologies.
Microsoft SQL Server Parallel Data Warehouse
— This is a highly scalable system for data
warehousing that employs massively parallel processing.
— This is the desktop database component of Microsoft Ofﬁce.
— This is the relational database management system (RDBMS) product from Oracle
FIGURE 31: The Get External Data section of the
PowerPivot Window ribbon
587379c03.indd 58 5/12/10 11:02:26 AM