By Haroon Choudry
23rd August 2018

Experience with the Microsoft BI full stack (SSIS, SSAS, SSRS) is in incredibly high demand with many organisations working with a heavy Microsoft tech stack, however nothing causes more controversy than one particular service in that stack; questioning the future of SSRS.

It is a well-known fact that Data Visualisation is growing massively, many organisations are getting on board with the likes of Tableau, Qlikview and most recently Power BI (a tool we ourselves use at KDR Recruitment). 

Is the rise of Power BI killing SSRS?

What is the purpose of SSRS?

SSRS (SQL Server Reporting Services) is part of the Microsoft SQL Server Suite alongside SSIS and SSAS. It is Microsoft’s tool for traditional paginated document-style reports, simply put- the more data you have, the more rows in a table therefore the more pages. SSRS is essentially used for analysing data and generating reports from a server. SSRS first came to market in 2004 and even though it is built on older technology it is used a lot within the BI function of organisations.

How has Power BI affected this?

Power BI is a data visualisation tool used for analysing data and generating interactive visual reports from either a server or the cloud. 

Power BI gives users a more interactive way of understanding data with its slick visualisations. Power BI now also has the capability to render analytical reports. It has now come to a point where Power BI can do almost everything SSRS can and then some! 

On paper choosing Power BI over SSRS seems like a no brainer, Educba did a great comparison table of the two which can be found below:



A discussion on LinkedIn surrounding the future of SSRS reflected how uncomfortable people are with the prospect of no SSRS. Here are some comments on one of my posts:

“SSRS was the first tool that I used in BI. It's too special to me. I can't see it die”

“Printing in Power BI is challenging. When a customer needs a printable report, we have to switch to SSRS.”

“It would have died if MS SQL 2016 would not have combined Power BI with SSRS together. They want it to survive for few more years may be.....”

It’s just a matter of time…

Microsoft SQL Server 17 didn’t include SSIS as part of the already included suite of tools. Candidates are telling me that Power BI will take over completely. This isn’t just the decline of SSRS, it’s the decline of your bog-standard printed reporting. 

Do you think SSRS is dying? Do you see Power BI taking over? Let me know the thoughts in the comments below!

KDR Recruitment is the home of the best Information Management and Data Analytics jobs. For more tech news and views check out the KDR blog or follow KDR on LinkedIn.

This blog was originally published on LinkedIn. To read the original blog, click here

View the latest data and analytics jobs


Very interesting tabled details.
Posted on Wednesday, August 29, 2018 07:57 by Sampath R.

Post Comment


Data Visualisation vs Traditional Reporting

Every quarter we produce an e-magazine focussing on issues and topics within the data and analytics world. In our previous editions we have looked at; data analytics and climate change , the impact of blockchain and the death of the data... Read More

The best data conferences in 2019

2019 is set to be another big year in data, technology and analytics. As more ‘smart’ technology is being released the amount of data being collected is only going to rise. At KDR we find one of the best ways... Read More

Top blogs of 2018

Every year we take a look back at which blogs of ours you read the most, and this year is no different. While we write around a mix of topics including: data analytics , AI , IoT and more , it seems our... Read More

Information Matters – Data Analytics and Climate Change

We are proud to announce the sixth edition of Information Matters ! As recruiters in the Information Management and Data Analytics industry we consider it vital to in the know about issues and events facing our industry and your business. Our... Read More

Where should we send our newsletter?