Exporting From Power BI To PowerPoint

One of Power BI’s great strengths is how easy it makes sharing dashboards and reports but there are occasions when you don’t want to.

This article explains how to export Power BI to PowerPoint using Power BI Service. 

You will see the two most commonly used methods to convert Power BI Report pages to PowerPoint slides: 

  1. Direct export, and 
  1. Copy / paste. 

Power BI Desktop only allows you to export Power BI reports to PDF. This is the licence typically used during Power BI training classes.

Power BI Services allows you to export reports as static images to Microsoft PowerPoint and PDF. See this article for more details on Power BI licences.

Why Export Power BI To PowerPoint?

Reasons you might want to export Power BI reports to PowerPoint include:

  1. Sharing information with people not familiar with Power BI.
  1. Power BI Service or Power BI desktop is not available.
  1. You have confidential information that cannot be shared via Power BI. See this article to learn more about Power BI security.
  1. You want to merge visuals from different BI tools ( Power BI, Tableau, etc.).

 

Sample Report to Export

Let’s first create a sample report with three pages. You will be exporting this Power BI report to PowerPoint. 

You can download the dataset used to generate the sample report from this link:

https://raw.githubusercontent.com/curran/data/gh-pages/superstoreSales/superstoreSales.csv

The dataset contains sales for various products in a fictional store between the years 2009 to 2012.

Page1: Monthly Information

This page contains a line chart and a 100% stacked column chart. 

The first page of the report looks like this:

screen shot of line chart and a 100% stacked column chart - Monthly Information

Page 2: Yearly Information

This page contains a line chart and a 100% stacked bar chart, as shown in the figure below:

screen shot of line chart and a 100% stacked bar chart - Yearly Information

Page 3: Profit by Category

This page contains two pie charts as shown below:

screen shot of two pie charts

Method 1: Exporting Directly from the Reports View

You can export Power BI to PowerPoint directly from the Reports View.

  1. Open any page of the report that you want to export.
  1. Click the “Export” link from the list of options at the top of the reports and select “PowerPoint” from the dropdown (see below).

 

red selection shows export and powerpoint options

 

You will see this screen.

 

screenshot showing screen with export option

 

  1. If you only want to export the currently open page of the report, tick the “Only export current page” option.

If you want to export all the report pages, leave this checkbox unchecked.

If you have any hidden pages or report tabs, the checkbox for the “Exclude hidden report tabs” will be enabled. Check this box if you don’t want to export the hidden tabs from your report.

  1. Click the “Export” button on the following screen to export Power BI to PowerPoint.

Power BI  will create a PowerPoint slide with the name of your report. 

If you open the PowerPoint document, you will see that it contains a title slide plus one slide for each of the pages in your Power BI report.

 

screenshot showing title slide plus one slide for each of the pages in your Power BI report

 

Our example Power BI report had three pages. The newly created PowerPoint will have four slides; a title slide and three content slides. 

If you look at the title slide, you will see that it contains a link to the original Power BI report.

 

yellow selection showing link to the original Power BI report

 

Method 2: Manually Copying & Pasting Visuals from Reports

The second option is a little crude. 

You simply copy the visuals from your Power BI reports and manually paste them into any application, including the PowerPoint. 

This method can be slow with extensive reports. 

You have to copy and paste the visuals one-by-one from your report.

An advantage of this method is that you can copy and paste the visuals of your choice. You can also select where in your slides the visuals are shown.

To copy a visual, click on the copy icon from the top right corner of a visual, as shown below:

 

red selection shows click on the copy icon from the top right corner of a visual

 

You will see the following screen. Here click the “Copy to clipboard” button.

 

screenshot shows Copy to clipboard option

 

Finally, paste the copied visual into your PowerPoint slides. 

As an example, see the screenshot below:

 

screenshot of pasting the copied visual into your PowerPoint slides

 

Three Things To Remember

  1. When you export Power BI to PowerPoint, the reports export as static images, they are not interactive like Power BI report pages. 
  1. Another limitation of exporting Power BI to PowerPoint is that this functionality is not available in Power BI Desktop. 
  1. You must use a manual snipping tool to snip a report visual and paste it to a PowerPoint slide when using Power BI desktop.

 

Final Thoughts

Exporting from Power BI to PowerPoint is very straightforward.

Hopefully, this tutorial has helped show you how!

About Ben Richardson

Ben is a director of Acuity Training. He writes about SQL, Power BI and Excel on a number of industry sites including SQLCentral, SQLshack and codingsight.