SQL Server – Reporting services 2016 News

Last modified date:

I finally got to MS SQL Server 2016 – Release candidate 3 installation during weekend. First thing I did was focusing on news regarding Reporting services 2016. Microsoft presents its new reporting services as a big thing full of innovations. It looks attractive, sorted and when you look closely you can see resemblance to Power BI (visualization, web portal UI).

Hardware and software requirements are here

Reporting services 2016 Web Portal

There is plenty of news. The most notable one is probably the new web portal replacing manager from the older versions on address domain/instance by default.

Reporting services 2016 web portal

SSRS 2016 web portal

Web portal is used to store reports, shared datasets and data sources. From now on we can also define KPIs and mobile reports. KPIs are created directly in web interface and we can enter them manually. We can also bind them to a prepared dataset thus making KPIs dynamic values that change automatically. KPIs are being used in mobile reports where managers have instant access to all important metrics which are also well organized.

Reporting services 2016 KPI detail

In right upper corner of web interface, there is a possibility to download software needed to produce reports.

  • Report builder
  • Mobile report publisher
  • Power BI desktop
  • Power BI mobile

Integration with Power BI Service

Reporting services 2016 is able to integrate – pin some parts of reports into Power BI dashboards. By doing that it uses full potential of SSRS (variability) and power bi (perfect visualization and interactivity) reports. All you need to do is:

  • register report server with Power BI in report configuration manager

Reporting services 2016 Power BI integration

  • Prepare report (either via report builder or Data Tools) – I made a small sales report using connection to freely downloadable SQL database Adventureworks which I installed to SQL server 2016 Release candidate 3 (will test it as soon as possible)

SQL Server 2016 Sales report

  • Pin graphs to your power bi dashboard by using Power bi logo

Significantly Improved Report Visualization

Options of report visualization improved significantly. Older version of report builder and Data tools were on the level of Excel 2010 until the version SSDT2013 in the matter of visualization. Therefore SSRS reports started to be less and less favorite amongst some users.

Even the fact that SSRS reports are capable of much more in some cases did not stop raising popularity of new game changers (Power BI).

My name is Jan Zedníček and I work as a BI Developer at Kentico Software in Brno. Mostly you can see me there working in the office, but I also work partly as a freelancer. I have been working as a freelancer for many companies for more than 5 years, but Kentico is the matter of my heart. I used to work as a financial controller at companies like Aero Vodochody or Sberbank and I also used to be a bond program manager in Unicapital Investment group. When I am not at work, I like playing volleyball, chess, doing a workout in the gym and I enjoy tasting of best quality rums. I am trying to summarize all my knowledge on this website not to forget them (because of the rum effect, you know =) and to put them forward to anyone. Don´t worry about asking for help or writing some comments.

Category: SSRS - Reporting Services

About Ing. Jan Zedníček - BI Developer, Finance controller

My name is Jan Zedníček and I work as a BI Developer at Kentico Software in Brno. Mostly you can see me there working in the office, but I also work partly as a freelancer. I have been working as a freelancer for many companies for more than 5 years, but Kentico is the matter of my heart. I used to work as a financial controller at companies like Aero Vodochody or Sberbank and I also used to be a bond program manager in Unicapital Investment group. When I am not at work, I like playing volleyball, chess, doing a workout in the gym and I enjoy tasting of best quality rums. I am trying to summarize all my knowledge on this website not to forget them (because of the rum effect, you know =) and to put them forward to anyone. Don´t worry about asking for help or writing some comments.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.