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

[Brijith]

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).

[v-prasare]

Hi @Brijith,

please post this query in below community forum.

Find Answers | Microsoft Power Platform Community

thanks,

prashanth

[julsr]

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]

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