cancel
Showing results for 
Search instead for 
Did you mean: 
ibarrau

[Power BI and Power Automate] Send a Power BI Alert Notification to Contacts

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.

ibarrau_0-1593691554617.png

When we have a card tile in the dashboard, we are ready to create the alert. Check the next picture:

ibarrau_1-1593691554608.png

 

There you have “Manage Alerts”.

addnewalertaddnewalert

We can configure the conditions clicking "+ add alert rule" and saving it. Let's open the alert again to check it has successfully created. Check the bottom hyperlink on the screen. Microsoft is showing a message that we can chain this behavior with an action with the Power Automate tool. In order to start Power Automate, click on the hyperlink:

hyperlinkalerttoautomatehyperlinkalerttoautomate

This will redirect us to Power Automate, with the suggested template as a default for our alert requirement. Let's click "Continue":

powerautomatealerttemplatepowerautomatealerttemplate

From now on, the work is in Automate. The flow starts with a Power BI connection, in which we can pick up alerts created. In my case, the alert's name is "Alerta de Alerta".

pickanalertinautomatepickanalertinautomate

Then, we can continue this flow with "+ New Step" to chain the next action that should be a notification to our contacts. For the notification I recommend two actions:
  • 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.

  1. From our Office 365 account with an exchange license.
  2. From an Outlook account.
  3. From a Gmail account.
  4. From a custom SMTP server.
  5. 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.

sendmailwithautomatesendmailwithautomate

Now we are ready. Our contacts will receive an email each time the data is refreshed with the rule working. It's important to mention that all the components we have used in Automate are free. You don't need an additional license for this at the moment.

I hope you can alert your mates faster now!

Meet Our Blog Authors
  • Experienced Consultant with a demonstrated history of working in the information technology and services industry. Skilled in Office 365, Azure, SharePoint Online, PowerShell, Nintex, K2, SharePoint Designer workflow automation, PowerApps, Microsoft Flow, PowerShell, Active Directory, Operating Systems, Networking, and JavaScript. Strong consulting professional with a Bachelor of Engineering (B.E.) focused in Information Technology from Mumbai University.
  • I am a Microsoft Business Applications MVP and a Senior Manager at EY. I am a technology enthusiast and problem solver. I work/speak/blog/Vlog on Microsoft technology, including Office 365, Power Apps, Power Automate, SharePoint, and Teams Etc. I am helping global clients on Power Platform adoption and empowering them with Power Platform possibilities, capabilities, and easiness. I am a leader of the Houston Power Platform User Group and Power Automate community superuser. I love traveling , exploring new places, and meeting people from different cultures.
  • Blog site: https://ganeshsanapblogs.wordpress.com/ MCT | SharePoint, Microsoft 365 and Power Platform Consultant | Contributor on SharePoint StackExchange, Techcommunity
  • Encodian Owner / Founder - Ex Microsoft Consulting Services - Architect / Developer - 20 years in SharePoint - PowerPlatform Fan
  • I am the Owner/Principal Architect at Don't Pa..Panic Consulting. I've been working in the information technology industry for over 30 years, and have played key roles in several enterprise SharePoint architectural design review, Intranet deployment, application development, and migration projects. I've been a Microsoft Most Valuable Professional (MVP) 12 consecutive years and am also a Microsoft Certified SharePoint Masters (MCSM) since 2013.
  • Big fan of Power Platform technologies and implemented many solutions.
  • Passionate #Programmer #SharePoint #SPFx #M365 #Power Platform| Microsoft MVP | SharePoint StackOverflow, Github, PnP contributor
  • Web site – https://kamdaryash.wordpress.com Youtube channel - https://www.youtube.com/channel/UCM149rFkLNgerSvgDVeYTZQ/