Add a Table (SSAS Tabular)
Applies To: SQL Server 2016
This topic describes how to add a table from a data source from which you have previously imported data into your model. To add a table from the same data source, you can use the existing data source connection. It is recommended you always use a single connection when importing any number of tables from a single data source.
In SQL Server Data Tools (SSDT), click the Model menu, and then click Existing Connections.
On the Existing Connections page, select the connection to the data source that has the table you want to add, and then click Open.
On the Select Tables and Views page, select the table from the data source you want to add to your model.
The Select Tables and Views page will not show tables that were previously imported as checked. If you select a table that was previously imported using this connection, and you did not give the table a different friendly name, a 1 will be appended to the friendly name. You do not need to re-select any tables that were previously imported by using this connection.
If necessary, use Preview & Filter to select only certain columns or apply filters to the data to be imported.
Click Finish to import the new table.