We're excited to announce that from 14th April we'll be running live online training courses too!
From 14th April we'll be running live online training courses too!
A comparison of SQL Server Reporting Services and Power BI
Part four 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.

  1. Reporting Services (SSRS) versus Power BI
  2. An overview of Power BI and SSRS
  3. Loading data (SSRS and Power BI compared)
  4. Creating reports for viewing on-screen (this blog)
  5. Exporting and printing reports
  6. Total Cost of Ownership (TCO)
  7. Conclusions

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.

Creating reports for viewing on-screen

This is a category which Power BI wins for ease of use and functionality, but SSRS probably still just wins for its range of features.

Creating reports in Power BI

The basic principle behind a Power BI report is that of visual interactions:

Visual interactions

Clicking on the Drama category in the column chart and the 18 certificate in the slicer at the top of the page means that you only see 18 Drama films in the table.

 

You can do very little in Power BI by clicking within a visual; instead, you change properties in the formatting tools provided in a separate ribbon.  For example, to change the appearance of the chart above you would need to first select it, then change its formatting properties:

Format properties

The long list of formatting properties for a column chart, for example.

This does mean that you have to guess which property you need to change (you can't just right-click on part of a visual to find out), and many properties that you'd like to change don't exist yet:

Missing properties

As one example, suppose that you wanted to underline the title of a visual. Here are the properties of a Title. As you can see, underlining is not (yet, at any rate) one of them, so you'll have to either a) wait until a Power BI update comes out to implement this or b) live without your underlining.

 

Power BI does have some conditional formatting, but not much yet:

Conditional formatting

Here we're setting the chart colour to be an expression depending (say) on the size of the number displayed, but as yet not many properties support conditional formatting like this.

 

To see what a report can look like when lots of different types of visuals are combined, consider this Power BI dashboard showing Devon road traffic data by Marie Woltman (you can see the live version here):

Devon road traffic data

Click on an area of the map to update all of the other tables and charts.

Finally, Power BI has numerous ways to support drill-down - here's one of them:

Drill-through

One of a few ways of enabling drill-through in Power BI.

Power BI is thus perfectly set up to create interactive dashboards (perfect for what-if analysis, or for impressing managers in board meetings).

Creating reports in SSRS

Creating reports in SSRS does feel like going back in time a bit.  Consider a grouped table like the one shown below:

Grouped table

This table is showing films by certificate.

To get this, you would create a table looking something like this:

Table of data

This table is anything but WYSIWYG (it's only when you preview the report that you see exactly what the table looks like).

SSRS doesn't support interaction:

No interaction

When you click on one of these report items, the other doesn't change (there is a way to enable drill-down, but it's a bit cumbersome).

Where SSRS does score is in the range of formatting that it can support.  Most properties that you'd want already there:

Textbox properties

The start of the list of properties for a textbox - it's pretty comprehensive.

 

However, you can also set almost any property of any object to depend on the value of an expression:

Text box expression

Here the font colour of a text box will depend on an expression (so you could use this to colour long films red and short films blue, for example).

 

What this shows is that (as so often in this blog) it's difficult to compare Power BI and SSRS because they are ... different.

This blog has 0 threads Add post