Part V: Understanding Power Pivot and Power Query
FIGURE 35.19
Select the worksheets you want to import.
When reading from external Excel files, Power Pivot allows you to select named ranges as well as entire worksheets.
This comes in handy when you want to import only a subset of data within a worksheet.
As discussed earlier in this chapter, you can use the Preview & Filter button to filter out
unwanted columns and records if needed. Otherwise, continue with the Table Import
Wizard 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.
Be aware that loading external Excel data does not give you the same interactivity you get with linked tables. Just
as with importing database tables, the data you bring from an external Excel file is simply a snapshot. You’ll need to
refresh the data connection to see any new data that may have been added to the external Excel file (see “Manually
refreshing your Power Pivot data” later in this chapter).
Loading data from text files
Text files are another type of flat file used to distribute data. These files are commonly out-
puts from legacy systems and websites. Excel has always been able to import text files. With
Power Pivot, you can go further and integrate them with other data sources.
