Edit

Share via


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.

    Screenshot of the Power Automate Send an e-mail to any audience when a Power BI data alert is triggered template option.

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.

    Screenshot of the Power Automate, Power BI to mail option.

  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.

    Screenshot that shows where to select an alert in the Alert ID box.

  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.

    Screenshot that shows the Power Automate auto-generated email text.

  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.

    Screenshot of the Power Automate success message.

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

    Screenshot of the Power Automate alert email.

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.

    Screenshot of the Power Automate > Create Automated cloud flow screen.

  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.

    Screenshot of the Build an automated flow screen.

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.

    Screenshot that shows how to select the name of the alert.

  2. Select New step.

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

    Screenshot that shows how to choose an action when you create an event.

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

    Screenshot that shows where to continue to build the flow.

  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.

    Screenshot of the message that indicates the flow is now running.

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

    Screenshot of the Power Automate triggers Outlook notification.