Sending email to external user with reports as attachment

[dratan99]

Hi,

I want to export Power BI reports to excel and send as attachment to multiple external users. I am also looking to send one single email with multiple reports as attachments. How can I achieve this? Please advice. Thanks

[DavisBI · Accepted solution]

Hi, @dratan99 ,

If you want to send report emails to multiple external users you should add all of them as guest users on Azure Portal.

Multiple attachments are not supported currently but maybe you can consider using PowerAutomate to do that trick (refer to here)

Mark this post as solution if this helps, thanks!

[dratan99]

Thanks Davis & Robert for your reply.

[v-robertq-msft · Accepted solution]

Hi, @dratan99 

In my opinion, you can not export the entire report to Excel in Power BI, you can export data from visualization in your report, or you can just export the report to PDF or PPT. To send an email with multiple reports to external users, you can take DavidBI’s advice, or you can just save your reports as pbix file and attach them to your email, like this:

To share content with external users in Power BI, you can check this document:

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-azure-ad-b2b

Best Regards,

Community Support Team _Robert Qin

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

[DavisBI · Accepted solution]

Hi, @dratan99 ,

If you want to send report emails to multiple external users you should add all of them as guest users on Azure Portal.

Multiple attachments are not supported currently but maybe you can consider using PowerAutomate to do that trick (refer to here)

Mark this post as solution if this helps, thanks!