Microsoft Analysis Services Projects 2022

Package includes support for Tabular and Multidimensional projects. After creating a new model project by using one of the templates, you can begin model authoring by using the designer tools and wizards included in the chosen project type. Among other things, you can import existing models from a server or start a new, blank model project.

Analysis Services modeling projects integrate with source control, such as Team Foundation Server and many third-party source control plug-ins. If you have configured Visual Studio to use source control, you can use check in/check out from Solution Explorer.

Visit https://blogs.msdn.microsoft.com/analysisservices/ for the latest information, tips, news, and announcements about Analysis Services directly from the product team.

Preview Release Candidate Builds If you'd like to have early access to release candidate builds before they are published to the VS Gallery, we’re making available to give customers an opportunity to provide feedback prior to finalizing releases. To access the release candidate of the extensions in Visual Studio, you may do so by creating a “private gallery” and entering the following settings.

• Navigate to Tools > Options and then select Extensions under Environment.
• Under "Additional Extension Galleries", enter the following details:
• Name: Microsoft BI VSIX Preview
• URL: http://aka.ms/VSIX2022

After entering these settings, your "Manage Extensions" dialog will show updates for the extension when there is a new release candidate that you can install to provide feedback for a day or two before the VS Gallery VSIX is updated.

Provide feedback and report issues with this Vsix Package or Analysis Services modeling projects in general to: https://learn.microsoft.com/en-us/visualstudio/ide/how-to-report-a-problem-with-visual-studio?view=vs-2022

Known Issues:-

1. In the context menu (right mouse button) on objects in the project (e.g. the solution, a package) in Visual Studio, many of the entries appear many times. This happens only when Microsoft Analysis Services Projects 2022 is installed together.
2. SSRS Map functionality is broken when used along with SSDT. While we fix that, Workaround can be used.

Workaround for map issue:-

1. Download https://www.nuget.org/packages/Microsoft.SqlServer.Types/160.1000.6
2. Extract the nuget package.
3. Copy "microsoft.sqlserver.types.160.1000.6\runtimes\win-x64\native\SqlServerSpatial160.dll" and "microsoft.sqlserver.types.160.1000.6\lib\net462\Microsoft.SqlServer.Types.dll"
4. Paste the above copied files in - C:\Program Files\Microsoft Visual Studio\2022\Enterprise\Common7\IDE\Extensions\Microsoft\SQLDB\DAC

New in the September 11th, 2023, Release of Microsoft Analysis Services Projects (VSIX Update 3.0.13)

• Fixed SAS authentication to connect to data source to import table in Tabular projects
• Fixed multiple user feedback prompts popping up in a multi project solution
• Standard bug fixes and stability improvements

If you encounter any issues with this latest release, you can get the previous release (3.0.11) at https://go.microsoft.com/fwlink/?linkid=2246411

New in the June 14th, 2023, Release of Microsoft Analysis Services Projects (VSIX Update 3.0.11)

• Azure Active Directory Authentication Library is getting deprecated soon, So SSAS have now migrated to Microsoft Authentication Library.
• Selection and Click issues on attribute relationships fixed.
• Standard bug fixes and stability improvements.

If you encounter any issues with this latest release, you can get the previous release (3.0.10) at https://go.microsoft.com/fwlink/?linkid=2239568

New in the February 28th, 2023, Release of Microsoft Analysis Services Projects (VSIX Update 3.0.10)

• Bug fixes on Feedback mechanism to capture customer sentiments on the product
• Addition of check-in status icons to solution explorer in Multidimensional projects
• Standard bug fixes and stability improvements

If you encounter any issues with this latest release, you can get the previous release (3.0.9) at https://go.microsoft.com/fwlink/?linkid=2226551

New in the February 8th, 2023, Release of Microsoft Analysis Services Projects (VSIX Update 3.0.9)

• Improved Feedback mechanism to capture customer sentiments on the product
• Standard bug fixes and stability improvements

New in the December 26th, 2022, Release of Microsoft Analysis Services Projects (VSIX Update 3.0.8)

• Resolved multiple UI issues for different screen sizes and resolutions
• Standard bug fixes and stability improvements

New in the November 17th, 2022, Release of Microsoft Analysis Services Projects (VSIX Update 3.0.7)

• Added support for SQL Server 2022 (1600) compatibility level in Tabular Projects
• Support provided for AAS Server redirection
• Added support for 64 bit driver when creating SSAS Tabular Project
• Fixed issue with authentication using credentials for SSAS Deployment Wizard
• Additional fixes including issues related to Linked Dimension, multidimensional project responsiveness, and more
• Fixed an issue with Process Partition button graying out in SSAS Tabular model
• Enhanced Accessibility by improving Narrator Feature in SSAS