Power Automate - Send email with Power BI Visualizations

[jerryr125]

Hi - 

Is there a resource (web site or video) that can demonstrate how to send out an email to a list of email addresses (table in Power BI) with a couple of charts embeded in the email ? The Charts do not need to be dynamic  - basically just embed the latest changes to the visualization in the email.  No filtering, etc...just create and send the the most current version of the visualizations.

Any thoughts ? jerryr

[v-xiaocliu-msft · Accepted solution]

Hi @jerryr125 ,

I made a simple sample for you.

Best Regards,

Wearsky

[lbendlin]

By themselves each of the steps are simple

- use the Embedded Playground to capture the visual ID of the visuals you want to export

- add the email addresses field to the Power Automate visual

- in the flow iterate over the "first table rows" if yoo want to send individual emails

- use the "Export to file - PNG"  action in Power Automate to render the visuals (including potential individual filters)

- embed the binary result of the rendering in the HTML of the email body.

Tying it all together is when it gets hairy, especially if you are planning to do this for more than a handful of email addresses.   This has a high potential for wasting a lot of your time.