Events
31 Mar, 23 - 2 Apr, 23
The ultimate Power BI, Fabric, SQL, and AI community-led event. March 31 - April 2. Use code MSCUST for a $150 discount. Prices go up Feb 11th.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Use Power Automate to integrate Power BI with your favorite apps and services. With Power Automate, you create automated workflows to get notifications, synchronize files, collect data, and more. In this article, you automate generating an email from a Power BI data alert.
This article shows how to create two different flows: one from a template and one from scratch. To follow along, create a data alert in Power BI, and sign up for Power Automate. It's free!
In this task, we use a template to create a flow that's triggered by a Power BI data alert (notification).
Sign in to Power Automate (https://flow.microsoft.com).
Select Templates, search for Power BI > Send an e-mail to any audience when a Power BI data alert is triggered.
This template has one trigger, a Power BI data alert, and one action, to send an email. As you select a field, Power Automate displays dynamic content that you can include. In this example, we include the tile value and the tile URL in the message body.
Select Continue.
In the Alert ID box, select a Power BI data alert. To learn how to create an alert, see Data alerts in Power BI.
Enter one or more valid email addresses.
Power Automate automatically generates a Subject and Body for you, which you can keep or modify. The body text uses HTML for formatting.
When you're done with the message, select New step or Save. Power Automate creates and evaluates the flow.
If Power Automate finds errors, it lets you know.
Select Edit flow to fix the errors. Otherwise, select Done to run the new flow.
When a change triggers a data alert, Power Automate sends an email to the addresses you indicated.
In this task, we create a simple flow from scratch that is triggered by a Power BI data alert (notification).
Sign in to Power Automate.
Select Create > Automated flow.
In Build an automated flow, give your flow a name.
In Choose your flow's trigger, search for Power BI.
Select Power BI - When a data driven alert is triggered > Create.
In the Alert ID box, select the name of your alert. To learn how to create an alert, see Data alerts in Power BI.
Select New step.
In Choose an action, search for Outlook > Create event.
Fill in the event fields. As you select a field, Power Automate displays dynamic content that you can include.
Select Create flow when done. Power Automate saves and evaluates the flow. If there are no errors, select Done to run this flow. The new flow is added to your My flows page.
When your Power BI data alert triggers the flow, you'll receive an Outlook event notification similar to this one.
Events
31 Mar, 23 - 2 Apr, 23
The ultimate Power BI, Fabric, SQL, and AI community-led event. March 31 - April 2. Use code MSCUST for a $150 discount. Prices go up Feb 11th.
Register todayTraining
Module
Get started with Power Automate - Training
Learn how to create simple flows to make your life easier.
Certification
Microsoft Certified: Power Automate RPA Developer Associate - Certifications
Demonstrate how to improve and automate workflows with Microsoft Power Automate RPA developer.