web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to automation of e...
Power Automate
Answered

How to automation of export Powerbi report to powerpoint with live data?

(1) ShareShare
ReportReport
Posted on by 2
PowerAutomate can automated export powreBI report to powerpoint but it is not "live data". How to export live data by powerautomate?
Categories:
I have the same question (0)
  • Suggested answer
    Michael E. Gernaey Profile Picture
    53,969 Moderator on at
    Hi
     
    Refresh the report first (use the power bi refresh action)
    Then export it
    That's as live as you will get.
     
  • Suggested answer
    SaiRT14 Profile Picture
    1,990 Super User 2025 Season 1 on at
    Check out the following steps:
    • Power BI REST API:  To export live data from Power BI to PowerPoint or another format, you can use the Power BI REST API to query the live data from a report or dataset.  Use Power Automate with the "HTTP request" action to call the Power BI REST API and retrieve the latest dataset information.

    • Retrieve Live Data:  Use the "Get Dataset" or "Query Dataset" API endpoints to extract the most up-to-date data directly from Power BI. The dataset or report should support real-time updates.  Example API Endpoint: https://api.powerbi.com/v1.0/myorg/datasets/{datasetId}/executeQueries

    • Process the Data:  Once you've retrieved the live data from Power BI, process or format the data using Power Automate to fit your desired export format (e.g., for PowerPoint or Excel).

    • Generate PowerPoint with Live Data:  Use a PowerPoint template and fill in the live data from Power BI using Power Automate actions like "Populate a Word template" or third-party connectors to insert dynamic content into the PowerPoint slides.

    • Email or Store the PowerPoint:  After generating the PowerPoint with live data, you can email it or store it in a location like OneDrive or SharePoint for easy access.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 589

#2
Valantis Profile Picture

Valantis 328

#3
David_MA Profile Picture

David_MA 284 Super User 2026 Season 1

Last 30 days Overall leaderboard