This page has 0 threads | Add post

Blogs

Finding our blogs useful? Please consider helping us to share more!

This blog shows how to create your first tabular project in Visual Studio Part four 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. Getting started with tabular model Analysis Services Checking you have Analysis Services Tabular running Running and Customising Visual Studio Creating a tabular project in Visual Studio (this blog) This blog is part of our online SSAS Tabular tutorial; we also offer lots of other Analysis Services training resources.

This blog shows how to create your first tabular project in Visual Studio

Part four 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.

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

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

Creating a tabular project in Visual Studio

Once you've gone into Visual Studio (and customised it to show Solution Explorer and the Properties window), you can create a project as shown below.

Creating a Tabular Project

You can choose to create a new project using this menu option:

You can press SHIFT + CTRL + N to do this too.

You can now choose to create a new tabular model project, and also choose where to put it:

Choose to create an Analysis Services BI project (and an Analysis Services Tabular Project to be specific).

Note that in the above dialog box, there's little point creating a directory for your solution:

If you tick this box, you just get an additional unwelcome folder in your hierarchy.

A solution allows you to view more than one project simultaneously, but for most Visual Studio developers it will be sufficient to have a single project open at a time.

You may now be prompted to choose your workspace server:

The workspace server is the Analysis Services instance which will contain any models that you create. It may be an idea to tick Do not show this message again, as you'll always want to use the SSAS instance running on your computer!

You can now see your project in Solution Explorer:

The files created for the project.

Every tabular project contains one (and only one) model, so there's not much left to do at this stage in Solution Explorer:

You can double-click on the Model.bim file to see your model (which to begin with will be completely blank).

Time now to go to the next part of this tutorial: a walk-through of creating a basic model.

Parts of this blog
Getting started with tabular model Analysis Services Checking you have Analysis Services Tabular running Running and Customising Visual Studio Creating a tabular project in Visual Studio (this blog)

Some other pages relevant to the above blogs include:

This blog has 0 threads

Add a new post

Head office

Kingsmoor House

Railway Street

GLOSSOP

SK13 2AA

London

Landmark Offices

99 Bishopsgate

LONDON

EC2M 3XD

Manchester

Holiday Inn

25 Aytoun Street

MANCHESTER

M1 3AE

Site map

Terms & Conditions

Book any course as classroom, onsite or online training, or as one-to-one consultancy

Free resources

Paid services

Getting help

Where we are

Where you are

Online

Transparent reviews

Delivery of courses

Nicer to work with

Reliable and established

Our training courses

C#

Excel

MySQL

Power Apps

Power Automate

Power BI and DAX

Python

Report Builder

SQL

SQL Server

VBA Macros

Other training resources

Blogs

Exercises

YouTube tutorials

YouTube shorts

Test your skills

Consultancy

Courseware

Self-paced courses

Newsletters

Publications

Our training venues

London

Manchester

Across the UK

At your site

Online

Why we are different

Hundreds of published reviews

Small class sizes

Outstanding courseware

Online classroom

(Almost) no cancellations

Wise Owl trainers only

Genuine integrity

Invoices after training

30+ years of Wise Owl

Our top 100 clients

BLOGS BY TOPIC

BLOGS BY AUTHOR

Creating a tabular project in Visual Studio

Creating a Tabular Project

Head office

London

Manchester