Skip to main content

Notifications

Power Automate - AI Builder
Answered

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

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:
  • Suggested answer
    SaiRT14 Profile Picture
    SaiRT14 317 on at
    How to automation of export Powerbi report to powerpoint with live data?
    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.

  • Verified answer
    FLMike Profile Picture
    FLMike 28,855 on at
    How to automation of export Powerbi report to powerpoint with live data?
    Hi
     
    Refresh the report first (use the power bi refresh action)
    Then export it
    That's as live as you will get.
     

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

September 2024 Newsletter…

September 2024 Community Newsletter…

Community Update Sept 16…

Power Platform Community Update…

Tuesday Tip #2 Global Search…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 142,008

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,531

Leaderboard