Share via

Specify a SQL or MDX Query (SSAS)

  • Article

This page of the Table Import Wizard enables you to import data by using a SQL or MDX query. To access the wizard from the SQL Server Data Tools, on the Model menu, click Import from Data Source.

The 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.

UI element list
Term Definition
Friendly Query Name Type a unique name for the query. This is a required field.
SQL Statement Type or paste a SQL statement.
Validate Determine if the SQL statement is valid.
Design Design a SQL statement by using the query designer dialog box. For more information, see Relational Query Designer (SSAS).