Add live Power BI data to PowerPoint

You can use live data from Power BI to help create a story with your PowerPoint presentations. Add individual visuals and whole report pages to your PowerPoint slides with the Power BI add-in or create a new PowerPoint presentation with live data from the Power BI Service. With the Power BI add-in, you can also use recommended content from the add-in to use on an existing slide. You also insert a direct URL link into the Power BI add-in.

After you use your preferred method to load the data, the report or visual will be live and you can select the data as desired. Any changes you make while editing the presentation will automatically save. The next time you open the presentation, the report or visual will appear in the state you last left it in. For more information, see View and present live Power BI data in PowerPoint.

Decide how you want to load your data and follow the procedure in one of following sections:

• Create a new presentation and add live Power BI data
• Add live Power BI data to an existing presentation
• Use the direct URL to add live data to a presentation

Create a new presentation and add live Power BI data

Create new presentation from a report or visual

Add the report or visual to a new PowerPoint presentation with the following method:

1. Go to the report or visual.
2. Make any changes or select filters that you want to the data before you add it to a new PowerPoint presentation.
3. Select Share the live data is a report.
4. Or, if the live data is in a visual, select More options (...) then Share.
5. When you add a report:
   1. Specify what users can access the content as described in the sharing reports documentation.
   2. Check the Include my changes box if you want to add the data in its current state.
   3. Select Apply.
6. Choose Open in PowerPoint.
7. In the Embed live data in PowerPoint dialog that appears, choose Open in PowerPoint. Then a new PowerPoint presentation will open with the visual already loaded into the add-in.

Export a report to add live data to a new presentation

1. Select Export.

2. Choose PowerPoint.

3. Then select Embed live data.

   

4. Check the Embed report with the data filters you selected box if you want to export the current state,

5. Select Open in PowerPoint.

Add live Power BI data to an existing presentation

Use the content recommended by the Power BI add-in

1. On the slide you want to add live content, type the title of the slide. The title should include the name of the report you wish to add.

2. select Add-Ins from the top ribbon.

3. Select the Power BI add-in.

4. The add-in then automatically scans the title of your slide then suggests Power BI content that might be relevant under the Recommended section.

   For example, if the title of your slide is "New stores sales," the add-in shows you a list of Power BI reports that contain those keywords. The add-in also shows you reports you recently visited in Power BI, so you can easily access reports you’re working on or frequently use.

   

5. Once you find the report you want, select it to insert it on the page.

6. When you have the report open on PowerPoint, you can select a specific page or visual to insert. You can also update filters or slicers before you insert it on the page.

7. If you want to allow others to access this report, select the Give people automatic access to this data checkbox, so that when others in your org view this presentation, they can see the data you added to the slide.

   Note

   You must have permission to share the content you want to insert or you won't have the option to give others access to the data.

8. When you're ready to insert the page, select the Insert button to add the live content.

Use the direct URL to add live data to a presentation

If you want to add a live report page to your presentation with a URL, there are three ways to get the report page URL, you can get the URL from the Share option, Export option, or directly from the browser's address bar.

Use the following procedure to add live data to a presentation with a URL:

1. In the Power BI service, open the report to the page you want to insert.

2. If you want, set the page to your desired state using filters, selection, slicers, etc.

3. If you use the share method, select Share:

   1. Specify what users can access the content.

   2. Check the Include my changes box if you want to add the data in its current state.

   3. Select Apply.

      

   4. Copy the URL.

4. Or, if you use a visual:

   1. Select More options (...).
   2. Select Share.
   3. Then choose Link to this visual to get the visual's URL.
   4. Copy the URL.

5. Or to use the browser link:

   1. Copy the URL from the browser's address bar.

6. After you copy the URL with one of the previously mentioned methods, go to your PowerPoint Presentation.

7. Go to the slide you want to add the data.

8. Select the Power BI add-in from the ribbon.

9. Paste the URL into the text box.

10. Select the Insert button and the visual will load into the slide.

    

Change a direct link to a shareable link

If you have sharable links enabled for your organization and you have permissions to re-share a report, you can turn your link into shareable link in the Power BI add-in. When you use a sharable link, other users viewing the presentation have the required permissions to see the report and don't have to request access when the viewing the presentation. So, you don't have to give everyone access in the Power BI service before you use the report in your presentation. For admins to learn more about how to enable sharable links, read Allow shareable links to grant access to everyone in your organization.

Use the following procedure to create a shareable link to a report in your presentation:

1. Copy the report page from the browser address bar.

2. Paste the direct link into the Power BI add-in.

3. Check the box next to Give people automatic access to this data. The add-in changes the direct link to a shareable link.

4. Select the Insert button and the report loads into the slide. The report will now be accessible to everyone who views the presentation.

   

Related content

• About storytelling with Power BI in PowerPoint
• View and present live Power BI data in PowerPoint
• Information for Power BI administrators
• Troubleshoot the Power BI add-in for PowerPoint
• More questions? Try asking the Power BI Community