Integrate Power BI data alerts with Power Automate

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.

Prerequisites

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!

Create a flow from a template

In this task, we use a template to create a flow that's triggered by a Power BI data alert (notification).

1. Sign in to Power Automate (https://flow.microsoft.com).

2. Select Templates, search for Power BI > Send an e-mail to any audience when a Power BI data alert is triggered.

   

Build the flow

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.

1. Select Continue.

   

2. In the Alert ID box, select a Power BI data alert. To learn how to create an alert, see Data alerts in Power BI.

   

3. Enter one or more valid email addresses.

4. Power Automate automatically generates a Subject and Body for you, which you can keep or modify. The body text uses HTML for formatting.

   

5. 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.

6. Select Edit flow to fix the errors. Otherwise, select Done to run the new flow.

   

7. When a change triggers a data alert, Power Automate sends an email to the addresses you indicated.

   

Create a flow from scratch

In this task, we create a simple flow from scratch that is triggered by a Power BI data alert (notification).

1. Sign in to Power Automate.

2. Select Create > Automated flow.

   

3. In Build an automated flow, give your flow a name.

4. In Choose your flow's trigger, search for Power BI.

5. Select Power BI - When a data driven alert is triggered > Create.

   

Build your flow

1. In the Alert ID box, select the name of your alert. To learn how to create an alert, see Data alerts in Power BI.

   

2. Select New step.

3. In Choose an action, search for Outlook > Create event.

   

4. Fill in the event fields. As you select a field, Power Automate displays dynamic content that you can include.

   

5. 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.

   

6. When your Power BI data alert triggers the flow, you'll receive an Outlook event notification similar to this one.

   

Related content

• Get started with Power Automate
• Export and email a Power BI report with Power Automate
• Create a Power Automate button visual
• More questions? Try the Power BI Community