Issue With SSDT (Visual studio 2019)

Deliz 1 Reputation point
2022-03-16T10:10:57.017+00:00

Hello All,

I have installed Visual Studio Community 2019 with Data Storage and processing including Sql Server Developer tools (SSDT I assumed)but could not see how to start a Tabular Project for Analysis Services. I investigated further and found that I should open VS and go to Extensions-> Manage Extensions -> and add the Microsoft Analysis Service Projects extension, completed successfully. When I go to New Projects I can select the Multidimensional and Data Mining option but it does not give me an option to select Tabular which is different to Multidimensional. I can't see any notes in MSDN that specifies how to install tabular mode.

Could you help me resolve this issue please...

Thanks in Advance

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,249 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Darren Gosbell 2,376 Reputation points
    2022-03-16T23:34:21.68+00:00

    I do not believe there is a separate option for installing the Tabular mode, when you install the Microsoft Analysis Services Projects extension you should see both types of projects in the project types on the left hand side of the new project options. Are you saying that you only see the Multidimensional section when you expand the Analysis Services category?

    Maybe try following the steps at the bottom of this page https://marketplace.visualstudio.com/items?itemName=ProBITools.MicrosoftAnalysisServicesModelingProjects to uninstall and reinstall the extension

    183868-image.png

    0 comments No comments

  2. ZoeHui-MSFT 33,626 Reputation points
    2022-03-17T07:14:12.217+00:00

    Hi @Deliz ,

    Please uninstalled the Analysis extension, closed VS. Reopened VS and added the extension again to see if you could see the tabular model.

    If this do not work, you may take a tabular projectfile from Adventureworks github:

    https://github.com/Microsoft/sql-server-samples/releases/tag/adventureworks-analysis-services

    And then open the project from VS 2019 to see if it could work.

    Regards,

    Zoe


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.