Hello,
I'm currently developing a workflow that involves exporting filtered content from Power BI to PowerPoint presentations, and I've encountered a challenge that I hope someone here can help me with.
Here's an overview of my workflow:
- Input Phase: Users upload one or more CSV files to a SharePoint site. These files serve as the data source for the Power BI report.
- Power BI Refresh Trigger: The uploading of files triggers an automatic refresh of the Power BI report.
- Refresh Completion Wait: The flow is designed to wait until the Power BI report refresh is complete before proceeding.
The next step is where I'm facing difficulties:
- Filtering and Exporting Reports: I need to apply a filter to the Power BI reports based on the Source.Name field and then export the filtered reports to PowerPoint (.pptx) format. However, I'm struggling with how to apply this filter within the flow. I couldn't find a relevant example in the documentation that could guide me through this process.
Additionally, I have the following requirements:
- Dynamic File Naming and Storage: The exported files should be named dynamically based on the file name of the input CSV files. So probably need to store them also here somehow.
I would greatly appreciate any guidance, examples, or references to documentation that could help me achieve the filtering, exporting, and dynamic file naming/storage aspects of my workflow.
Thank you in advance for your help!
