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

7. Click the table name to highlight it and then click the Preview & Filter button.
The Table Import Wizard displays the preview screen shown in Figure 4-5, where you see all
the columns available in the table, with a sampling of rows.
Figure 4-5: The Preview & Filter screen allows you to filter out columns you don't need.
8. Choose the columns that you want to import in the table.
Each column header has a check box next to it, indicating that the column will be imported
with the table. Deselecting the check box tells Power Pivot to not include that column in the
Data Model.
You can also filter certain records. Click the drop-down arrow for any of the columns and
choose the criteria to filter unwanted records, as shown in Figure 4-6. This works just like the
standard filtering in Excel. You can select and deselect the data items in the filtered list, or if
there are too many choices, you can apply broader criteria by choosing Date Filters (if you're
filtering a textual column, this is Text Filters).
9. After you're done selecting your data and applying any needed filters, click the Finish button
in the Table Import Wizard.
The import log shown in Figure 4-7 shows the progress of the import and summarizes the
import actions taken after completion.