Choose How to Import the Data (SSAS)

This page of the Table Import Wizard enables you to choose how to import data from the selected data source. To access the wizard from the SQL Server Data Tools, on the Model menu, click Import from Data Source.

• Select from a list of tables and views to choose the data to import
  Select this option if you want to import data by selecting from a list.

  Note

  This option is available only when the selected data source exposes schema information that the Table Import Wizard supports.

• Write a query to specify the data to import
  Select this option if you want to import data by using a SQL query. The SQL query can manipulate the data that is imported. For example, you could join data from different tables or select only rows that meet certain criteria.