[Power BI and Power Automate] Send a Power BI Alert Notification to Contacts
08-27-202009:04 AM
I have recently answered a lot of forum posts about sending alerts to their contacts about KPI rules. I have read about it and found out it can't just be with Power BI alone. We will use free Power Automate components to build this. Let's see how the process is done.
The first thing we need is a tile in a dashboard pinned from a visualization in a report.Let's keep in mind that the only visualizations that allow alerts are gauges, KPIs and cards. In this example, we are pinning a card to a dashboard. Follow the arrows to go through.
There you have “Manage Alerts”.
hyperlinkalerttoautomate
This will redirect us to Power Automate, with the suggested template as a default for our alert requirement. Let's click "Continue":
pickanalertinautomate
Teams: We can send a chat to a team or personalized channel with our account (requires a team license).
Email: Send an email to specified addresses.
In the email case, there are five different ways to do this. The difference is in the "From" sending the mail.
From our Office 365 account with an exchange license.
From an Outlook account.
From a Gmail account.
From a custom SMTP server.
From Power Automate send by Microsoft Power Apps and Power Automate <microsoft@powerapps.com>
The configuration is straight forward except for the smtp option. You can use one or more of them in parallel. This post will pick the 5th email option. At the end, save the flow.
NOTE: Keep in mind that you can use the alert title in the body of the mail.
I hope you can alert your mates faster now!
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.