Install Visual Studio 2022 and the SQL Server Analysis Services (SSAS) extension (front-end)

Подписаться 17 тыс.

Просмотров 17 тыс.

50% 1

Let's have a look at how to install Visual Studio 2022 and the SQL Server Analysis Services (SSAS) extension
My SQL Server Udemy courses are:
70-461, 70-761 Querying Microsoft SQL Server with T-SQL: rebrand.ly/que...
98-364: Database Fundamentals (Microsoft SQL Server): rebrand.ly/dat...
70-462 SQL Server Database Administration (DBA): rebrand.ly/sql...
Microsoft SQL Server Reporting Services (SSRS): rebrand.ly/sql...
SQL Server Integration Services (SSIS): rebrand.ly/sql...
SQL Server Analysis Services (SSAS): rebrand.ly/sql...
Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model): rebrand.ly/mic...
----
Visual Studio 2022 is a front engine for SQL Server Analysis Services. Let's see how to install both VS and the SSAS extension.
First of all, you need to install Visual Studio 2022. The community edition is free.
Then, you need to open Visual Studio and go to Extensions - Manage Extensions and install the extension.

Опубликовано:

7 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 13

@SQLServer101 Год назад

This video is for SSAS. For other components, please go to ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kci5AgUqStQ.html for SSRS, and ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-RJl22PBuv_Q.html for SSIS.

@dileepkumarreddyg8840 2 года назад

Very good explanation, most of the video in youtube show only SQL developer installation.

@youssefkabir6664 Год назад

think you so much

@AhmedZaidiii 2 года назад

I installed SSAS Extension but it is only showing multidimensional and not tabular. Can you help please?

@justinpapin6397 Год назад

Analysis Services projects 2022 is not compatible with tabular model connected to azure synapse dedicated SQL pool (data warehouse). This is really annoying, and no communication from Microsoft on if they are going to fix this. This information should be clearly stated in the documentation. If you are using synapse, you need to download and use the 2019 version

@SQLServer101 Год назад

Hi Justin. That's annoying to hear - but at least you use can use the 2019 version for the time being. However, you may want to connect to Azure Synapse through (say) Power BI direct - see learn.microsoft.com/en-us/answers/questions/888090/azure-synapse-dedicated-sql-pool-and-powerbi?page=1 for details. Phillip

@GeekSP1 2 года назад

Hi, when i click download its downloading a .zip file, not .vsix file

@777maddox 2 года назад

After installation, multidimensional project analysis is appearing but tabular project is not appearing. please guide.

@SQLServer101 2 года назад

Hi Dwipayan. If you go to File - New Project, you should see both "Analysis Services Multidimensional Project" and "Analysis Services Tabular Project". If you can see one but not the other, try using the "Search for templates" to look for it. Phillip