Create Tabular Model in SSAS 2016

Leave a comment

We will go through an example of how to create a new tabular model in SQL Server Analysis Services 2016 (SSAS).

Open SQL Server Data Tools (SSDT) and create a new Analysis Services Tabular project:


A new project will be created:

Model.bim contains the following properties:

Add data source connection:

Connect to SQL data warehouse:

To add tables to the model, click Model->Existing Connections:


Mark the date table as date table:

Change the view to Diagram View and see the table relationships:

Add a new column Extended Price and type the formula:

Create a new measure and add a DAX formula:

Build and save the solution.

In SSAS, you will now see the new database:



Carl de Souza is a developer and architect focusing on Microsoft Dynamics 365, Power BI, Azure, and AI.

carldesouza.comLinkedIn Twitter | YouTube


Leave a Reply

Your email address will not be published. Required fields are marked *