We’re happy to announce the popular and long-awaited Analysis Services, RDLC Report Designer, and Reporting Services extensions are available for Visual Studio 2022! Here’s how these Microsoft extensions for SQL Server can further enhance your business intelligence solution development environment.
SQL Server Analysis Services (SSAS)
The Microsoft Analysis Services extension adds project templates and design tools to easily create tabular and multidimensional data models in SQL Server Analysis Services, Microsoft Azure Services, and Power BI. These data model projects can also be integrated with source control repository providers such as Team Foundation Server.
SQL Server Reporting Services Projects (SSRS)
The Reporting Services Projects extension provides a report definition (*.rdl) designer, projects (*.rptproj), and wizards for creating professional reports for Microsoft Reporting Services. The designer lets you modify, preview, and deploy report definitions and datasets within Visual Studio.
RDLC Report Designer
To display SQL Server Reporting Services reports in WebForms and WinForms applications, Report Definition Language Client-Side (RDLC) files are used by Visual Studio Report Viewer controls. The RDLC Report Designer extension allows you to present database displays in Visual Basic and .NET with the provided new projects definitions and adds tools to create and manage RDLC reports within Visual Studio.
Continued Extension Development
Work for the SQL Server Integration Services (SSIS) extension in Visual Studio 2022 is on the roadmap for a future release. For more information about the progress, you can check the Visual Studio Developer Community. Please let us know in the comments of other important extensions you’d like to see in Visual Studio 2022!
Any chance SSAS Tabular Cubes will support the 1550 compatibility level any time soon (lineage tag incompatibility is a real drag)? Also, would love to see the BISM Normalizer extension available in 2022. Thanks!
I am using this new version however when I view a table in the import it does not show all the tables columns, I have 2 columns at the end, one an int the other a bigint which are not showing up. I have tried deleting and recreating the DB connection but it still does not show up.
This is great but any updates on SQL Server Integration Projects (SSIS) being supported in VS 2022 anytime soon?
Great question. Probably not but a great question. For now, I’ll keep using VS2019 I guess.
At last!!! Great news! 🙂