Exporting SQL Server Reporting Services Reports to PowerPoint

By:   |   Updated: 2016-01-11   |   Comments (1)   |   Related: More > SQL Server 2016


This tip covers a new Reporting Services 2016 feature: exporting reports to PowerPoint.


A new feature introduced in the SQL Server 2016 preview CTP 2.4 is the ability to export reports to PowerPoint. To test this functionality, I used the sunburst chart from this tip How to create a Sunburst Graph in SQL Server Reporting Services 2016.

Sunburst example

The careful reader may have noticed that in the latest CTP 3.0 release, the sunburst now by default starts with the biggest slice at 12 o'clock. This was one of the remarks in the sunburst tip, but it has already been fixed by the SSRS team.

When the report is run, you can simply select PowerPoint from the export drop down menu.


If you don't see PowerPoint listed, you can check the report server configuration file (RSReportServer.config) to see if the PPTX rendering extension is registered and visible. There's a known bug that when you upgrade SQL Server 2016 from an older CTP to CTP 2.4, the PPTX rendering extension is not installed. In that case it's better to install a brand new SSRS instance using CTP 2.4 or later.

When the report is rendered, you'll get a dialog prompting you to save the PowerPoint file. When you open the file, you can see the result:

PPT export

The title and the footer have been translated to separate text boxes and the chart has been converted to an image. Now let's add a table to our report:

Add table

When exported to PowerPoint, the table has been converted to an image as well and not to a PowerPoint table.

PPT export with table

Actions (such as linking to a URL) are preserved on textboxes (like the title for instance), but not on charts or tablixes. In the following export, there's an action defined on the title and the table, but only the title can be clicked in PowerPoint.

PPT export with actions

Just like in most rendering extensions - like PDF for example - you have to pay attention to the size of your report body and its objects inside. If not, it's possible your report is spread out over multiple PowerPoint slides. It can even happen that the generated image of your chart or table is divided in multiple pieces. Here is an example:

PPT export with incorrect size
Next Steps

Last Updated: 2016-01-11

get scripts

next tip button

About the author
MSSQLTips author Koen Verbeeck Koen Verbeeck is a BI professional, specializing in the Microsoft BI stack with a particular love for SSIS.

View all my tips
Related Resources

Comments For This Article

Thursday, April 13, 2017 - 1:00:22 PM - Dave Back To Top

Thanks! Shame they dont let you export to powerpoint in portrait. they give the option but it doesnt do anything. 



Recommended Reading

New Drop If Exists Syntax in SQL Server 2016

New CREATE OR ALTER statement in SQL Server 2016 SP1

Automatic Updates for SQL Server Management Studio

SQL Server 2016 Always Encrypted

Advanced Techniques to Transform Relational Data to JSON in SQL Server 2016

get free sql tips
agree to terms

Learn more about SQL Server tools