Exporting SQL Server Reporting Services Reports to PowerPoint

By:   |   Comments (3)   |   Related: > 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

sql server categories

sql server webinars

subscribe to mssqltips

sql server tutorials

sql server white papers

next tip

About the author
MSSQLTips author Koen Verbeeck Koen Verbeeck is a seasoned business intelligence consultant at AE. He has over a decade of experience with the Microsoft Data Platform in numerous industries. He holds several certifications and is a prolific writer contributing content about SSIS, ADF, SSAS, SSRS, MDS, Power BI, Snowflake and Azure services. He has spoken at PASS, SQLBits, dataMinds Connect and delivers webinars on MSSQLTips.com. Koen has been awarded the Microsoft MVP data platform award for many years.

This author pledges the content of this article is based on professional experience and not AI generated.

View all my tips

Comments For This Article

Sunday, September 27, 2020 - 11:12:58 AM - Koen Verbeeck Back To Top (86539)
Hi Sharita,

No, I haven't tried it.
I haven't seen any new changes to this feature since the publication of the article.


Friday, September 25, 2020 - 1:19:37 PM - Sharita Farhana Back To Top (86535)

Have you figured out how to make the content of the SSRS report editable in powerpoint?

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

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


get free sql tips
agree to terms