In this example, based on data in the AdventureWorksDW2012 database, we will create a tabular project with SSDT from an empty project. You will see a variety of data sources that are supported and how easy it is to work in the tabular modeling environment.
Open SSDT, and from the Files menu, choose a new project, and then from the Business Intelligence templates under Analysis Services, choose Analysis Services Tabular Project. Name this project
Chapter 03 Tabular
.You might see a dialog box titled tabular model designer that asks for a tabular connect option, so enter the SSAS Tabular server's connection details and click on OK.
A new tabular project will be created. Now, from the Model menu, choose Import from Data Source.
In the Import Table Wizard, you will see a list of data source types that can be used to import data. Choose Microsoft SQL Server and continue.
Create a connection to AdventureWorksDW2012. In the Impersonation Information option...