557 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
A comparison of SQL Server Reporting Services and Power BI
Part six of a seven-part series of blogs
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.
It's not possible (or sensible) to try to compare Power BI and SSRS in pure financial terms, but you can consider the issues you'll face when choosing one or the other for your reports. These are:
How much will the software cost to buy/license?
How long will it take to create reports using each product?
Let's consider each of these costs in turn.
Microsoft licensing is not only (unnecessarily) complicated, but also depends on your company's setup. However other things being equal it seems to this owl that SSRS is a much cheaper option from the point of view of software purchase.
Power BI is free, until you want to share your reports. At this point you can either buy a monthly Power BI Pro licence for each user at $9.99 per month, or buy a Power BI Premium licence (which will set you back thousands of pounds a month).
The marginal cost of Reporting Services is zero. If you're intending to use SSRS, you'll already be paying for a SQL Server licence. The SSRS report authorship tools are free to download, and the Visual Studio editing software is free if you download the Community edition (subject to licensing conditions).
Note that if you're lucky enough to have an Office 365 Enterprise 5 (E5) licence Power BI is included at no additional cost.
We're in a particularly good position to give an opinion on the relative ease of use of Power BI and SSRS, since we've trained many people on many courses in each!
It's definitely easier to get started with Power BI:
Creating a table is as easy as just clicking on a field.
It's also far easier to load data:
Power BI makes it easy to load tables of data, and automatically links them together where possible.
If you're content to create basic reports, Power BI is thus far cheaper to adopt than SSRS. Where things get murkier is when you want to create measures:
For any non-standard calculations such as the one shown here, you're going to have to create measures using DAX (a non-trivial task).
DAX is a difficult and unintuitive formula language to learn, and many Power BI users will struggle with it (the Quick Measures wizard can help to some extent, and we also run a two-day DAX course).
Thus I would say that for normal Power BI reports the learning curve is shallow, but to become a Power BI guru you are going to have to learn and understand the concepts of row context and filter context, and also learn how to create DAX expressions (the learning curve for which is steep).
Most people find Reporting Services relatively easy to learn (our two-day SSRS course shows everything you need to know to create all but the most advanced reports):
However, you will probably need to attend a course (for example, it's not at all obvious how you apply grouping to a table like this one).
But ... this isn't the end of the story. I've done a few consultancy projects for clients building reports in SSRS, and I would estimate that you will spend half your time creating the reports and the other half writing SQL to massage the data into the right format.
|Parts of this blog|
25 Aytoun Street