30 Nov’19

OthersHow to create Tabular Model Project

In this blog, we will learn how to create blank Tabular model project.

Pre-requisite:

  1. Visual Studio with Business Intelligence template.
  2. Data source to import data into Tabular model (in our case we are using SQL Server).
  3. Analysis Server to deploy Tabular model.

 

  1. Go to Visual Studio, and create new project, go to Templates > Business Intelligence > Analysis Services > Analysis Services Tabular Project, give a name and click on OK.
  2. Once click on OK following window will appear to select Analysis services instance.
  3. Select the workspace server in our case workspace server name is “localhost”, Compatibility level as “SQL Server 2017/ Azure Analysis Services(1400)” and Click on Test connection to check whether, it is connected to workspace server or not.
  4. After clicking on OK project will be created and we can see the Tabular model Explorer, under that we can see the following sections:
    Data Sources, Expressions, KPI etc. as shown in below snapshot

And in solution explorer we can see the solution details

In this way we can create Tabular project, in next blog we will import data source in it.

Written by

Gurunath Vishwakarma

Associate Software Engineer- Power BI

Leave a Reply

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

Want to streamline your business processes?

  • This field is for validation purposes and should be left unchanged.

Recent Articles

  • How to create Dynamics 365 Finance & Operations (formerly Dynamics AX) connection in SSIS

    12 December’ 2019

    Introduction: Creating a Connection is one of the first Steps during the integration of data. While performing Integrati...

    Read more
  • How to create AX (D365 F&0) Connection in SSIS

    12 December’ 2019

    Introduction: Creating a Connection is one of the first Steps during integration of data. While performing Integration w...

    Read more
  • First cut review of new D365 Project Service

    12 December’ 2019

    The new Project Service coming up is a much-advanced version of PSA. Even more, than it will be called as Project Servic...

    Read more
  • Business Central Wave 2 Features – Section 4

    11 December’ 2019

    Introduction: In this blog, I will be attempting to provide information about the new Modern Client features of Business...

    Read more
  • Business Central Wave 2 Features – Section 5

    11 December’ 2019

    Introduction: In this blog, I will be attempting to provide information about the new Modern Client features of Business...

    Read more

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close