Select Tables and Views (Data Feeds) (SSAS)

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 SQL Server Data Tools, on the Model menu, click Import from Data Source.

The appearance of tables and views on this page does not guarantee that import will succeed. If the user specified in the Impersonation Information page does not have sufficient privileges to read from the selected database, import will fail.

For data sources using Windows authentication, the credentials of the current user are used to fetch the tables and views in the Select Tables and Views dialog. For other data sources, the credentials supplied in the connection string are used to fetch the data.

  • 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 (SSAS).

  • 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 (SSAS).

  • Select Related Tables
    Select tables that are related to the tables and views that you have selected.