Loading External Data into Power Pivot - Microsoft Business Intelligence Tools for Excel Analysts - page 79

3. Fill in the information the wizard needs to connect to your target workbook. Click Next when
you're done.

In this screen (see Figure 4-16), you need to provide

Friendly Connection Name: This field allows you to specify your own name for the external
source. Enter a name that is descriptive and easy to read.

●

Excel File Path: Enter the full path of your target Excel workbook. You can click the Browse
button to search for and select the workbook you want to pull from.

●

Use First Row as Column Headers: In most cases, your Excel data will have column headers.
Select the Use First Row as Column Headers check box to make sure your column headers
are recognized as headers when imported.

●

Figure 4-16: Provide the basic information needed to connect to the target workbook.

4. In the Select Tables and Views screen (see Figure 4-17), select the worksheets you want to
import.

The Friendly Name column allows you to enter a new name that will be used to reference the
table in Power Pivot.

When reading from external Excel files, Power Pivot cannot identify individual table
objects. As a result, you can only select entire worksheets in the Table Import Wizard
(shown in Figure 4-17). Keeping this in mind, make sure you import worksheets that
contain one single range of data.

Note

5. (Optional) Click the Preview & Filter button if you need to filter unwanted columns and
records.

6. Click Finish to complete the import process.

As always, be sure to review and create relationships to any other tables you've loaded into
the Power Pivot Data Model.