Forum Discussion
Sending Out Automated Emails With A Report Attached
Hi BO7,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Community SupportHi BO7,
Thank you for reaching out. Also thanks for lbendlin for your inputs on this thread. Based on your flow and description, it appears you are trying to send a Power BI report as an attachment via email using Power Automate. You are on the right track, but there's an essential step missing.
The flow you have created runs a dataset query and generates CSV/HTML tables, but it does not actually export the Power BI report file (such as a PDF or PowerPoint), which is why the attachment is missing in the email.
To send the complete Power BI report as an attachment, please use the “Export to File for Power BI Reports” action. This will generate a file (PDF or PPTX) that can be attached to an email.
For detailed instructions, refer to the official Microsoft documentation here:
Automate Power BI report export using Power Automate
Updated Flow Overview: Initiate with a recurrence trigger, followed by an optional delay or "Wait" if needed for export completion. Next, export the file for Power BI Reports and send an email (V2). In the email action, attach the "Export to File" output and specify the attachment name.
Requirements: Power BI Pro license, report stored in a workspace with Premium or PPU capacity, and access permissions to the report.
If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.
Thank you for using Microsoft Community Forum.
Community SupportHi BO7,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.