{"id":51260,"date":"2025-06-19T09:00:00","date_gmt":"2025-06-19T16:00:00","guid":{"rendered":""},"modified":"2025-10-08T15:16:08","modified_gmt":"2025-10-08T22:16:08","slug":"enhancing-reporting-and-analytics-with-sql-server-2025-tools-and-services","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2025\/06\/19\/enhancing-reporting-and-analytics-with-sql-server-2025-tools-and-services\/","title":{"rendered":"Enhancing reporting and analytics with SQL Server 2025 tools and services"},"content":{"rendered":"
\n\t
\n\t\t

\n\t\t\tSQL Server 2025 public preview announcement\t\t<\/p>\n\t\t\n\t\t\tRead the blog<\/span> <\/span>\n\t\t<\/a>\n\t<\/div>\n<\/div>\n\n\n\n

At Microsoft Build 2025, we announced the public preview of SQL Server 2025. Built on a foundation of best-in-class security, performance, and availability, SQL Server 2025<\/a> empowers customers to accelerate AI using their own data. The momentum doesn\u2019t stop there. This release also brings major updates to the tools and services that power enterprise-grade reporting, analysis and integration services. In this blog, we\u2019ll walk you through what\u2019s new across these services so you can plan your upgrade holistically and unlock the full potential of SQL Server 2025.<\/p>\n\n\n\n

\n
Get started with SQL Server 2025<\/a><\/div>\n<\/div>\n\n\n\n

\n SQL Server 2025 Reporting Services\n<\/h2>\n\n\n\n

\n For over two decades, SQL Server Reporting Services (SSRS) has been the go-to on-premises solution for creating and managing paginated reports using Report Definition Language (RDL). With SQL Server 2025, we\u2019re taking a step forward.\n<\/p>\n\n\n\n

\n Power BI Report Server will now be the default reporting solution for SQL Server 2025. This modern platform supports both paginated and interactive reports, enabling users to build reusable data models and deliver rich, customized reporting experiences. It also offers built-in compatibility with Power BI, providing a seamless path to the cloud.\n<\/p>\n\n\n\n

\n As part of this transition, we will not be releasing a new version of SSRS for SQL Server 2025. However, if you prefer to continue using SSRS, support will remain in place for both SQL Server 2025 and all in-market versions of SQL Server.\n<\/p>\n\n\n

\"Power<\/figure>\n\n\n\n

If you\u2019re testing SQL Server 2025 preview, we recommend including the move to Power BI Report Server in your upgrade plan. Download the free trial<\/a> of Power BI Report Server and explore the latest features to see if it meets your reporting needs. When SQL Server 2025 becomes generally available, any customer with a paid SQL Server license will have access to Power BI Report Server, which was previously limited to Enterprise edition customers with Software Assurance.<\/p>\n\n\n\n

For customers currently using Enterprise edition of SQL Server 2022 or earlier with Software Assurance, migrating from SQL Server Reporting Services (SSRS) to Power BI Report Server (PBIRS) is a straightforward process<\/a>. Most RDL report assets created in SSRS are fully compatible with PBIRS, making the transition less effort for the majority of users.<\/p>\n\n\n\n

For more questions, review the FAQ<\/a>. <\/p>\n\n\n\n

SQL Server 2025 Analysis Services <\/h2>\n\n\n\n

SQL Server 2025 Analysis Services (SSAS) introduces several key enhancements aimed at improving performance, scalability, and modeling flexibility. <\/p>\n\n\n\n

We have made significant performance improvements for Multidimensional Expressions (MDX) queries on models with Calculation Groups and Format Strings to reduce memory usage and improve responsiveness. The latest changes will greatly improve the performance and reliability of operations in Analyze in Excel on models that include Dynamic Format Strings for Measures and Calculated Items with Format Strings. For more details, refer to the Dynamic format strings <\/a>documentation. <\/p>\n\n\n\n

Improved parallelism in DirectQuery mode enables faster response times for complex queries. The fundamental idea is to maximize query performance by parallelizing multiple queries to the datasource for a single Data Analysis Expressions (DAX) query. This query parallelization reduces the impact of data source delays and network latencies on query performance.<\/p>\n\n\n\n

For more details, refer to the Query parallelization helps to boost the Power BI dataset performance in DirectQuery mode<\/a> blog post.<\/p>\n\n\n\n

SSAS 2025 incorporates the latest version of Horizontal Fusion, a query performance optimization that reduces the number of SQL queries generated by DAX, improving DirectQuery efficiency. For more details, refer to the Announcing \u201cHorizontal Fusion,\u201d a query performance optimization in Power BI and Analysis Services<\/a> blog post.<\/p>\n\n\n\n

Find more about what\u2019s new in SQL Server 2025 Analysis Services<\/a>.<\/p>\n\n\n\n

SQL Server 2025 Integration Services<\/h2>\n\n\n\n

\n One of the notable updates in SQL Server 2025 Integration Services (SSIS) is the improved support for ADO.NET connectivity. Historically, the ADO.NET connection manager had limitations such as the lack of ability to connect using Entra ID authentication. This posed challenges for organizations adopting modern identity solutions and cloud-first strategies.\n<\/p>\n\n\n\n

Now, with the introduction of the Microsoft SqlClient Data Provider in ADO.NET connection manager, SSIS addresses this gap. This new capability brings the support for Entra ID authentication, enabling more secure and flexible connection scenarios. <\/p>\n\n\n\n

Find more about what\u2019s new in SQL Server 2025 Integration Services<\/a>.<\/p>\n\n\n\n

Explore more resources<\/h2>\n\n\n\n