Learn about what's new in SQL Server Reporting Services. This covers the major feature areas and is updated as new items are released.
To download the January 2017 Technical Preview of Power BI reports in SQL Server Reporting Services, along with the Power BI Desktop release (SQL Server Reporting Services), go to the Microsoft download center.
To download SQL Server 2016, go to Evaluation Center.
Have an Azure account? Then go Here to spin up a Virtual Machine with SQL Server 2017 already installed.
For the current release notes, see Technical Preview of Power BI reports in SSRS - Release notes or SQL Server 2016 Release Notes.
Query designer support for DAX now in Report Builder and SQL Server Data Tools
In the latest releases of Report Builder and SQL Server Data Tools – Release Candidate, you can now create native DAX queries against supported SQL Server Analysis Services tabular data models. You can use the query designer in both tools to drag and drop the fields you want and have the DAX query generated for you instead of writing it yourself.
Read more on the Reporting Services blog.
Note: You can only use the query designer for DAX with SSAS tabular data sources built in SQL Server 2016+.
What's new in the January 2017 Technical Preview of Power BI reports in SQL Server Reporting Services
Reporting Services has a new setup experience
Reporting Services can now be installed outside of the SQL Server setup. The setup experience has fewer steps and is more lightweight. Setup will install the files for Reporting Services. You can then configure the database for your report server. This does require that you have access to a SQL Server Database Engine server in your environment.
For more information, see Install the January 2017 Technical Preview of Power BI reports in SQL Server Reporting Services.
Host Power BI reports within the web portal
You can now upload your Power BI Desktop files to Reporting Services and view reports directly in the web portal.
You will need to download the Power BI Desktop release (SQL Server Reporting Services). Currently the preview only supports reports created in this version of Power BI Desktop. Power BI Desktop (SQL Server Reporting Services) can exist side by side with the Power BI Desktop for the Power BI service. To download Power BI Desktop (SQL Server Reporting services), go to the Microsoft download center.
Currently, you are limited to creating a Power BI report against live connections to Analysis Services (tabular or multidimensional). We plan on adding support for other data sources and using Power Query features in a future preview.
For more information, see Power BI reports in Reporting Services.
What's new in SQL Server 2016
Reporting Services web portal
A new Reporting Services web portal is available. This is an updated, modern, portal which incorporates KPIs, Mobile Reports, Paginated Reports, Excel and Power BI Desktop files. The web portal replaces Report Manager from previous releases. You can also download Mobile Report Publisher and Report Builder from the web portal without the need of ClickOnce technology.
To create Mobile Reports, you will need the Mobile Report Publisher.
For more information about the web portal, see Web portal (SSRS Native Mode).
Custom branding for the web portal
You can customize the web portal with your organization's logo and colors by using a branding pack.
For more information about custom branding, see Branding the web portal
Key performance indicators (KPI) in the web portal
You can create KPIs direct in the web portal that are contextual to the folder you are in. When creating KPIs, you can choose dataset fields and summarize those values. You can also select related content to drill-through to more details.
For more information, see Working with KPIs in the web portal
Reporting Services mobile reports are dedicated reports optimized for a wide variety of form factors and provide an optimal experience for users accessing reports on mobile devices. Mobile reports feature a assortment of visualizations, from time, category, and comparison charts, to treemaps and custom maps. Connect your mobile reports to a range of data sources, including on-premises SQL Server Analysis Services multidimensional and tabular data. Lay out your mobile reports on a design surface with adjusting grid rows and columns, and flexible mobile report elements that scale well to any screen size. Then save these mobile reports to a Reporting Service server, and view and interact with them in a browser or in the Power BI mobile app on iPads, iPhones, Android phones and Windows 10 devices.
Mobile Report Publisher
The SQL Server Mobile Report Publisherallows you to create and publish SQL Server mobile reports to your Reporting Services web portal.
For more information, see Create mobile reports with SQL Server Mobile Report Publisher.
SQL Server mobile reports hosted in Reporting Services available in Power BI Mobile app
The Power BI Mobile app for iOS on iPad and iPhone can now display SQL Server mobile reports hosted on your local report server.
You can't connect by default without some configuration changes. For more information on how to allow the Power BI Mobile app to connect to your report server, see Enable a report server for Power BI Mobile access.
Support of SharePoint mode and SharePoint 2016
SQL Server 2016 Reporting Services supports integration with SharePoint 2013 and SharePoint 2016.
For more information, see:
Microsoft .NET Framework 4 Support
SQL Server 2016 Reporting Services (SSRS) supports the current versions of Microsoft .NET Framework 4. This includes version 4.0 and 4.5.1. If no version of .Net Framework 4.x is installed, SQL Server setup installs .NET 4.0 during the feature installation step.
HTML 5 Rendering Engine: A new HTML5 rendering engine that targets modern web "full" standards mode and modern browsers. The new rendering engine no longer relies on quirks mode used by a few older browsers.
For more information on browser support, see Browser Support for Reporting Services and Power View.
Modern paginated reports: Design beautifully modern paginated reports with new, modern styles for charts, gauges, maps and other data visualizations.
Tree Map and Sunburst Charts: Enhance your reports with Tree Map and Sunburst charts, great ways to display hierarchal data. For more information, see Tree Map and Sunburst Charts in Reporting Services.
Report embedding: You can now embed mobile and paginated reports in other web pages, and applications, by using an iframe along with URL parameters.
Pin Report Items to a Power BI Dashboard: While viewing a report in the web portal, you can select report items and pin them to a Power BI dashboard. The items you can pin are charts, gauge panels, maps, and images. You can (1) select the group that contains the dashboard you want to pin to, (2) select the dashboard you want to pin the item too and (3) select how frequently you want the tile updated in the dashboard. The refresh is managed by Reporting Services subscriptions and after the item is pinned, you can edit the subscription and configure a different refresh schedule.
For more information, see Power BI Report Server Integration (Configuration Manager) and Pin Reporting Services items to Power BI Dashboards.
PowerPoint Rendering and Export: The Microsoft PowerPoint (PPTX) format is a new SQL Server 2016 Reporting Services (SSRS) rendering extension. You can export reports in the PPTX format from the usual applications; Report Builder, Report Designer (in SSDT), and the web portal. For the example the following image shows the export menu from the web portal.
You can also select the PPTX format for subscription output and use Report Server URL access to render and export a report. For example the following URL command in your browser exports a report from a named instance of the report server.
For more information, see Export a Report Using URL Access.
PDF Replaces ActiveX for Remote Printing: The report viewer toolbar ActiveX print experience has been replaced with a modern PDF based experience that works across the matrix of supported browsers, including Microsoft Edge. No more ActiveX controls to download! Depending on the browser you use and the PDF viewing applications and services you have installed, Reporting Services will either open a print dialog to print your report or prompt you to download a .PDF file of your report. As an administrator, you can still disable client side printing from Management Studio. For more information, see Enable and Disable Client-Side Printing for Reporting Services.
|Feature||Supported server mode|
|Enable and disable subscriptions. New user interface options to quickly disable and enable subscriptions. The disabled subscriptions maintain their other configuration properties such as schedule and can be easily enabled.
For more information, see Disable or Pause Report and Subscription Processing.
|Subscription description. When you create a new subscription, you can now include a description of the report as part of the subscription properties. The description is included on the subscription summary page.||SharePoint and Native mode|
|Change subscription owner. Enhanced user interface to quickly change the owner of a subscription. Previous versions of Reporting Services allow administrators to change subscription owners using script. Starting with the SQL Server 2016 release, you can change subscription owners using the user interface or script. Changing the subscription owner is a common administrative task when users leave or change roles in your organization.||SharePoint and Native mode|
|Shared credential for file share subscriptions. Two workflows now exist with Reporting Services file share subscriptions:
New in this release, your Reporting Services administrator can configure a single file share account, that is used for one to many subscriptions. The file share account is configured in the Reporting Services native mode configuration manager Specify a file share account, and then on the subscription configuration page, users select Use file share account.
Configure individual subscriptions with specific credentials for the destination file share.
You can also mix the two approaches and have some file share subscriptions use the central file share account while other subscriptions use specific credentials.
SQL Server Data Tools (SSDT)
The new release of SSDT includes the project templates for SQL Server 2016 Reporting Services (SSRS): Report Server Project Wizard and Report Server Project. For information about downloading SSDT, see SQL Server Data Tools for Visual Studio 2015.
Report Builder improvements
New Report Builder User Interface: The core Report Builder user interface is now a modern look and feel with streamlined UI elements.
Custom Parameters Pane: You can now customize the parameters pane. Using the design surface in Report Builder, you can drag a parameter to a specific column and row in the parameters pane. You can add and remove columns to change the layout of the pane. For more information, see Customize the Parameters Pane in a Report (Report Builder).
High DPI Support: Report Builder for SQL Server 2017 supports High DPI (Dots Per Inch) scaling and devices. For more information on High DPI, see the following:
What's New in Analysis Services
Technical Preview of Power BI reports in SSRS - Release notes
SQL Server 2016 Release Notes
Reporting Services Features Supported by the Editions of SQL Server 2016
Upgrade and Migrate Reporting Services
Reporting Services (SSRS)