BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
Power BI improves with each monthly update. Will it reach a point where SSRS (SQL Server Reporting Services) becomes redundant? This detailed blog compares the two products, and considers the future of SSRS.
Posted by Andy Brown on 18 October 2019
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
Reporting Services (SSRS) versus Power BI
It's a popular question on training courses: what is the future for SSRS, and will Power BI supersede it?
We think we're uniquely well-placed to answer this question, being experienced (we've been training on both products to an advanced level for a fair few years) and independent (we have no axe to grind either way).
To compare the use and future of the two applications, I've divided this blog into the following parts:
|1 - Overview||A quick look at a typical Power BI and typical SSRS report.|
|2 - Loading data||A comparison of linking to data sources for the two applications.|
|3 - On-screen||Creating reports for viewing on-screen in Power BI and SSRS.|
|4 - Off-screen||Exporting and printing reports in Power BI/SSRS.|
|5 - TCO||A look at the total cost of ownership for the two products.|
|6 - Conclusions||My thoughts on the future of SSRS and Power BI.|
Let's start with a quick overview of the two products, so that we know exactly what we're talking about!