Forum Discussion
Sending Out Automated Emails With A Report Attached
Hello,
I am currently using Power Automate to send out autmated emails that attach a Power BI report. The email works, but there are no attachments. I'm not sure what I am doing wrong.
Here is a top-level view of the flow I am using:
Please note that I am not required to use Power Automate; if there is a simpler way to go about this, please let me know.
Thank You,
- Ben
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.
4 Replies
- lbendlin
Super User
What's the purpose of the CSV table?
You need to include the HTML table in the email body.
There are no attachments since you didn't specify any.
Hello,
I was able to figure out what I was doing wrong. I'm new to Power Automate so it was a case of me not adding something.
Thank You,
- Ben
v-kpoloju-msftCommunity Support
Hi 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.- v-kpoloju-msft
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.
