Forum Discussion

Brijith's avatar
Brijith
New Member
4 months ago

Power BI export single page to PowerPoint using Power Automate by iterating filter

Hi ,

I have a  published powerBI report with 1 page

I need to Export this Power BI report page to PowerPoint by iterating an ID. Example: if there are 10 IDs in the table, the output should be one PPT with 10 slides, each slide showing the same page filtered to a different ID, fully automated (no manual bookmarks).

Need Help

3 Replies

  • julsr's avatar
    julsr
    Continued Contributor
    4 months ago

    Hi Brijith 

     

    To clarify, your exact goal (one .pptx with N slides from one report page) is practical: each automated export job produces one output file, and with a single-page report the exported PPTX is typically one slide per report page for that job’s captured state. So getting 10 slides usually means either merging 10 one-slide decks.

     

    I think that you are using Power Automate + Power BI REST API Export To File with format = PPTX, and set powerBIReportConfiguration so each loop iteration applies a different reportLevelFilters value for your ID (please cofirm this or how are you iterating throught multiple pages). However if you must deliver one deck what could work is the following: keep the API-per-ID pattern, then merge presentations using an approach your organization already supports (for example Azure Automation / Azure Functions / Office automation), because Power Automate alone does not always offer a first-class, no-code PPTX merge story.

    https://learn.microsoft.com/en-us/office/open-xml/open-xml-sdk

     

    Let me know if you have any questions or more information available!

     

     

    • Brijith's avatar
      Brijith
      New Member
      4 months ago

      Thanks julsr , 
      I’ve built the flow and the ID filtering works. My issue is Creating one PPTX: each ExportToFile run gives me a separate (single‑slide) PPTX, and moving Create file outside the loop didnt work.
      Any recommendations ? Here is my flow