Notifications
Announcements
I'm currently leveraging Power Automate to export Power BI reports as PDF attachments from SharePoint to email. My workflow functions well for a single file source, but I need to adapt it to accommodate multiple files from SharePoint.
Specifically, I'm working with several CSV files (e.g., excel1.csv, excel2.csv, excel3.csv) stored in SharePoint, all formatted identically. I've successfully configured Power BI to source from this multiple file setup by targeting the folder containing these files. However, I'm encountering difficulties in adjusting the Power Automate flow to generate and attach a PDF report for each of these files, named correspondingly (excel1.pdf, excel2.pdf, excel3.pdf) and filtered by their names.
Could anyone guide me on how to modify my flow to achieve this? Any insights or guidance would be greatly appreciated!
Thank you in advance for your help.
Your left path contains a fallacy. "Refresh a dataset" is an asynchronous action. It will not wait for the completion of the dataset refresh, nor will it even know if the refresh was successful. Your flow will instead move on, and export the old version of your data (pre-refresh).
Hi, thanks for your reply. Is there a workaround for that? Something like 'wait till refresh finishes' ?
Yes, I described that in another post here somewhere. Either by polling for the presence of the end date for the first item in the history, or by using enhanced refresh and request ID. Requires a custom connector.
Hi @lbendlin, thanks for reply. Could you recall the post you are talking about? Unable to find it
Power Automate refresh Power BI Error 429 - Power Platform Community (microsoft.com)
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Michael E. Gernaey 538 Super User 2025 Season 2
Tomac 405 Moderator
abm abm 252 Most Valuable Professional
