Preview Selected Table
This page of the Table Import Wizard enables you to preview the data in the selected table, to select the columns to include in the data import, and to filter data in the selected columns. To access the wizard from the PowerPivot window, on the Home tab, in the Get External Data group, click the type of data source from which you want to import tables.
Not all the rows in the table are displayed. However, the filters that you set will be applied to all of the data in the table during import.
Checkbox in the column header
Select the checkbox to include the column in the data import. Clear the checkbox to remove the column from the data import.Down-arrow button in the column header
Filter data in the column.Clear Row Filters
Remove all filters that were applied to the data in the columns.