This page has 0 threads | Add post

Blogs

Finding our blogs useful? Please consider helping us to share more!

A comparison of SQL Server Reporting Services and Power BI Part five 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. Reporting Services (SSRS) versus Power BI An overview of Power BI and SSRS Loading data (SSRS and Power BI compared) Creating reports for viewing on-screen Exporting and printing reports (this blog) Total Cost of Ownership (TCO) Conclusions

A comparison of SQL Server Reporting Services and Power BI

Part five 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.

Reporting Services (SSRS) versus Power BI
An overview of Power BI and SSRS
Loading data (SSRS and Power BI compared)
Creating reports for viewing on-screen
Exporting and printing reports (this blog)
Total Cost of Ownership (TCO)
Conclusions

Posted by Andy Brown on 18 October 2019

Exporting and printing reports

From one of Power BI's great strengths, we turn to one of its weaknesses (and conversely, Reporting Services' great strength).

Exporting and printing in Power BI

So you've created the perfect report. You've published it either to Power BI Service or to your internal reporting portal, and everyone can see it. But Bobby in Accounts has a question for you: "I can print this or export it to Excel ... can't I?". Well, Bobby - no, you can't - or at least not very well.

You can export a report in Power BI Service as follows:

You can send a report to either PowerPoint, a PDF file or a printer.

Here's what each gives. First, PowerPoint:

You get a presentation, with one slide for each page of your report - plus a cover sheet.

A PDF is probably the best option for printing:

The PDF output from a single-page report.

Finally, here's what the print preview option looks like for this report:

The print preview screen for Power BI.

The problem isn't really that Power BI doesn't print; more that the sort of reports that you create using Power BI aren't meant to be printed.

As for Excel, you can export the data for an individual visual to a CSV file or Excel workbook:

Here I'm exporting the data for a chart to Excel.

Here's what I get for this in Excel:

This shows the underlying data for the chart, with the current filter applied.

So you can export the data for each visual, but you can't save an entire report as an Excel workbook.

Exporting and printing reporting from SSRS

By contrast, SSRS is designed to create reports for printing or for saving as Excel workbooks:

The tools which appear in preview mode include options to export data to a variety of different formats, or (as here) to change the page set-up.

Page set-up allows you to set your page margins and orientation:

It's not quite as whizzy as Excel, but it contains all the basics.

You can save a report to one of seven different formats:

Excel is the most commonly used export format for SSRS.

You can automatically generate a workbook containing one group's data on each worksheet:

This workbook was created automatically by exporting a report of films grouped by genre to Excel.

So we've reached the unsurprising conclusion that SSRS is good for producing printed reports and for automatically generating Excel workbooks, and Power BI is good at showing pretty visuals on screen!

Parts of this blog
Reporting Services (SSRS) versus Power BI An overview of Power BI and SSRS Loading data (SSRS and Power BI compared) Creating reports for viewing on-screen Exporting and printing reports (this blog) Total Cost of Ownership (TCO) Conclusions

Some other pages relevant to the above blogs include:

This blog has 0 threads

Add a new post

Book any course as classroom, onsite or online training, or as one-to-one consultancy

Free resources

Paid services

Getting help

Where we are

Where you are

Online

Transparent reviews

Delivery of courses

Nicer to work with

Reliable and established

Our training courses

C#

Excel

MySQL

Power Apps

Power Automate

Power BI and DAX

Python

Report Builder

SQL

SQL Server

VBA Macros

Other training resources

Blogs

Exercises

YouTube tutorials

YouTube shorts

Test your skills

Consultancy

Courseware

Self-paced courses

Newsletters

Publications

Our training venues

London

Manchester

Across the UK

At your site

Online

Why we are different

Hundreds of published reviews

Small class sizes

Outstanding courseware

Online classroom

(Almost) no cancellations

Wise Owl trainers only

Genuine integrity

Invoices after training

30+ years of Wise Owl

Our top 100 clients

BLOGS BY TOPIC

BLOGS BY AUTHOR

Exporting and printing reports

Exporting and printing in Power BI

Exporting and printing reporting from SSRS

Head office

London

Manchester