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 ...
Need Help
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