This blog shows how to create your first tabular project in Visual Studio
Part two of a four-part series of blogs

Before you can get started with tabular SSAS, you need to check you have Analysis Services (tabular model) installed on your computer. This blog also shows you how to run and configure Visual Studio, and how to create your first tabular project.

  1. Getting started with tabular model Analysis Services
  2. Checking you have Analysis Services Tabular running (this blog)
  3. Running and Customising Visual Studio
  4. Creating a tabular project in Visual Studio

This blog is part of our online SSAS Tabular tutorial; we also offer lots of other Analysis Services training resources.

Posted by Andy Brown on 11 November 2015

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Checking you have Analysis Services Tabular running

You can check what SSAS services you have running using either or both of SQL Server Configuration Manager and SQL Server Management Studio.

Checking using Configuration Manager

You can use SQL Server Configuration Manager (among other tools) to check you have an instance of SQL Server Analysis Services (tabular model) running:

SQL Server Configuration Manager

Choose this option to run SQL Server Configuration Manager.


You can now see if you have an instance of Analysis Services running:

SSAS running

Not only is this instance of SSAS running (which is good news), but it's set to start automatically when you turn on your computer.

Of course, this could be running in multi-dimensional mode, so you now need to check this in Management Studio!

Using SSMS to check the type of Analysis Server instance running

You can now run Management Studio to check on your SSAS instance:

Running SSMS

If you don't know how to run Management Studio, you probably shouldn't be reading this blog!


You can now choose to connect to Analysis Services:

Connecting to SSAS

Choose to connect to your Analysis Services database.

If the icon next to your server looks like this, you're using tabular SSAS:

The tabular icon

The icon for a tabular database looks like this.


Compare this with the other possible icons (taken from this StackOverflow article):

Three SSAS icons

The icons for multi-dimensional, tabular and PowerPivot modes respectively.


OK - things are looking good, so let's now use Visual Studio and customise its settings. 

This blog has 0 threads Add post