How to auto send emails with details in power bi

[nicoleouyang]

Hi all, I have created a table in power bi. And the data source will update every day. I need to send an email to a public mail box every day and in the email body is the full table from power bi, not the link of power bi dashboard. Or even it can be an excel file attached in the email. So how to make it happen automatically? Can I achieve this through set flow? Thanks a lot!

[v-joesh-msft · Accepted solution]

Hi @nicoleouyang ,

As mentioned in the post below:

PowerBI Export - Scheduling and Send Export to Excel by Email

"You could use Paginated Reports to get this done by connecting it to the same dataset. And then using the Subscription email from Paginated reports and attach the Excel file."

Best Regards,

Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[nicoleouyang]

Hi~~ Thank you for your reply. As there is only a table in powerbi, if it can be achieved to display the table in email body, instead of an excel attachment? Thanks you so much!

[v-joesh-msft]

Hi @nicoleouyang ,

Do you want to view the data or you need to edit the data, if you just want to view the data, you can try to Subscribe yourself and others to reports and dashboards in the Power BI service, you will receive an email with a snapshot of the report page or dashboard, with a link to open the report or dashboard. If you want the data to be editable, you need to open the report and select export data

Best Regards,

Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.