Select Tables and Views (Data Feeds)
Looking for help with Power Pivot in Excel 2013? Go to Power Pivot Help on Office.com.
This page of the Table Import Wizard enables you to select the tables and views that you want to import data from. 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. For more information about importing data from data feeds, see Import Data from a Reporting Services Report and Import Data from a Data Feed.
Data feed URL
Displays the URL for the data feed that you selected.Tables and views
Lists the tables and views in the data feed. Select the checkbox beside each table and view that you want to import.Source Table
Specifies the name of the source table based on the type of data source.Friendly Name
Specifies the friendly name of the source table. By default, the column displays the name of the source table that appears in the Source Table column.Filter Details
Displays the data import filter in the Filter Details dialog box, when a filter has been applied to the data that is being imported. For more information, see Filter Details.Preview and Filter
Displays the Preview Selected Table dialog box that is used to apply a filter to the data that is being imported. For more information, see Preview Selected Table.Select Related Tables
Select tables that are related to the tables and views that you have selected.
See Also
Tasks
Import Data from a Reporting Services Report