SSAS Tabular Part 2: Create a New Data source Connection in Tabular solution

To create a connection to a the AdventureWorksDW2012 database

• In SQL Server Data Tools, click on the Model menu, and then click Import from Data Source.
• In the Table Import Wizard, under Relational Databases, click Microsoft SQL Server, and then click Next.

• In the Connect to a Microsoft SQL Server Database page, in Friendly Connection Name, type Adventure Works DB from SQL.
• In Server name, type the name of the server you installed the AdventureWorksDW database.
• In the Database name field, click the down arrow and select AdventureWorksDW, and then click Next.

• In the Impersonation Information page, you need to specify the credentials Analysis Services will use to connect to the data source when importing and processing data. Verify Specific Windows user name and password is selected, and then in Domain\User Name and Password, enter your Windows logon credentials, and then click Next.

• Now Choose Select from a list of tables and views to choose the data to import Option.

• You will get all Tables with Views exists in AdventureWorksDW2012 database.

By selecting checkbox of particular table, you can Import some table data in to model.

NOTE: In some situation you may need to import other tables which are not in this current model. So, you have to connect database again through datasouce and get the tables.

This time many people do mistake by clicking the 'Import from datasource' option.

If you do the same, then SSDT asked to renter your user, Password and Database .you will get expected table with data. SSDT will create one more datasorce connection for that, which is wrong method to implementation.

The correct process is:

Go to Model and click on 'Existing Connections'. You will get the connection you have created previously. Now press on 'Open' button and go ahead by click 'Next'  Button.