Import from Analysis Services (SSAS Tabular)
Applies To: SQL Server 2016
This topic describes how to create a new tabular model project by importing the metadata from an existing tabular model by using the Import from Server project template in SQL Server Data Tools (SSDT).
You can use the Import from Server project template to create a new tabular model project by copying the metadata from an existing tabular model on an Analysis Services server. The new project will be created with the same data source connections, tables, relationships, measures, KPIs, roles, hierarchies, perspectives, and partitions as the model it was imported from. The data, however, is not copied from the existing model to the new model workspace. Once the import process has completed, and the new model project created, you must run a Process All to load the data from the data sources into the new model project workspace database.
In SQL Server Data Tools, on the File menu, click New, and then click Project.
In the New Project dialog box, under Installed Templates, click Business Intelligence, and then click Import from Server.
In Name, type a name for the project, then specify a location and solution name, and then click OK.
In the Import from Analysis Services dialog box, in Server Name, specify the name of the Analysis Services server that contains the model metadata you want to import.
In Database Name, select the tabular model database that contains the model metadata you want to import, and then click OK.