How to EMBED a Power BI Report DATA Directly Into An Alert Driven EMAIL Using Power Automate

In this example, I’ll be using Power Automate to send an email alert to a maintenance manager if the maintenance cost YTD is greater than the maintenance budget YTD.

The Power Automate flow will be designed to run every month. It will get the value for the cost vs. budget percentage difference. If it’s above 0 i.e. is over budget, then I’ll send an alert email.

The email will contain a table showing each month of the year and the budget cost, actual maintenance cost and budget vs. actual cost difference %. It will also contain a link to the original report in Power BI.

Note this approach uses:
- Power BI to provide the data
- Power Automate to process the logic that decides what action to carry out
- Power Automate to format and send out the email

You will also dip into:
- Power BI Queries
- JSON file structure
- Power Automate Expressions
- HTLM style formatting

The good news is that I’ll talk you through each of these technologies step-by-step.

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Recent Posts

About the author 

Jason Davidson

Jason Davidson is the founder of He is a maintenance and reliability engineer who uses Power BI every day to create dashboards that help him and others make better decisions. In his spare time, he likes running and has recently got into photography. He also loves spending time hanging out and larking about with his two daughters.

FREE Power BI Quick Start Course

Learn how to build a Power BI dashboard in under 90 minutes.