How to Send Automatic Email from Power BI

Your Power BI dashboard is full of valuable insights, but you can’t keep your eyes glued to it 24/7 waiting for something important to happen. Instead, you can turn your static reports into a proactive notification system that emails you and your team the moment a key metric changes. This guide will walk you through setting up automatic emails fired directly from Power BI.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Set Up Automated Emails from Power BI?

Automating email alerts based on your data transforms your dashboard from a passive reporting tool into an active business monitoring system. Instead of waiting for you to find an insight, the insight finds you.

Here are a few common scenarios where this is incredibly useful:

• Sales KPIs: Automatically notify the sales manager and the account executive when a rep hits their monthly quota or if a high-value deal is marked as "Closed-Won" in the CRM data.
• Marketing Performance: Get an email if a campaign’s spend suddenly spikes or if website conversion rates drop below a critical threshold for more than an hour.
• Inventory Management: Send an alert to the operations team when the stock level for a popular product, tracked in real-time, goes below the safety threshold.
• Project Management: Notify a project lead if a project’s budget exceeds 80% of its allocation or a key deadline is approaching with tasks still incomplete.

These automated alerts ensure that your team can react immediately to opportunities and threats without having to manually check reports, saving time and preventing critical information from being missed.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Method 1: Sending Scheduled Reports with Power BI Subscriptions

The simplest way to send emails from Power BI is by using the built-in "Subscriptions" feature. This method lets you email a snapshot of a report or dashboard to yourself and others on a fixed schedule. It's essentially a recurring, scheduled report delivered directly to your inbox.

This method is best for: Regular updates, like a "Monday Morning Sales Summary" or a "Daily Performance Snapshot," rather than real-time, data-driven alerts.

How to Set Up a Subscription

Setting this up is straightforward, but you’ll need a Power BI Pro or Premium license to use it.

1. Navigate to Your Report or Dashboard: Open the Power BI report or dashboard you want to share in the Power BI service.
2. Click "Subscribe": Look for the "Subscribe" icon (it looks like an envelope) in the top menu bar and click it. Select "Add new subscription."
3. Configure Your Subscription: A panel will appear on the right side of your screen. This is where you configure the email notifications.
4. Save and Close: Once you've configured the settings, click "Save and close." Your subscription is now active, and the recipients will get their first email at the next scheduled time.

While useful for recurring reports, subscriptions have limitations. You can’t trigger an email based on a specific data condition - it only runs on a predefined schedule. To send alerts based on what the data is actually doing, you'll need a more powerful tool: Power Automate.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Method 2: Sending Conditional Alerts with Power Automate

For true automation, you want an email to send only when your data meets a certain condition - for example, when sales exceed $10,000 for the day. This requires combining Power BI with Power Automate (previously known as Microsoft Flow), which opens up a world of possibilities for creating custom workflows.

This method is best for: Critical notifications that need to be sent immediately when specific data thresholds are met.

This process has two main parts: first, setting an alert on a dashboard tile in Power BI, and second, building a "flow" in Power Automate that sends the email when that alert is triggered.

Part 1: Setting up a Data-Driven Alert in Power BI

You can only create alerts on dashboard tiles that show a single number, like KPIs, cards, or gauges. You cannot set alerts on line charts or maps directly.

1. Pin a Visual to a Dashboard: Open your Power BI report and find a Card, KPI, or Gauge visual displaying the metric you want to monitor. Hover over it, click the pin icon, and pin it to an existing or new dashboard.
2. Access the Alert Settings: Go to the dashboard where you just pinned the tile. Hover over the tile, click the three dots (...) for more options, and select "Manage alerts."
3. Create the Alert: In the "Manage alerts" pane, click "+ Add alert rule."
4. Once you save this, Power BI will start monitoring the tile. When the threshold is crossed, a notification will appear in your Power BI Notification Center. But to send an email, we need to connect this alert to Power Automate.

Part 2: Building the Automated Workflow in Power Automate

Now, let's head over to Power Automate to tell it what to do when your Power BI alert is triggered.

1. Start a New Flow: Log in to Power Automate with your Microsoft account. Navigate to "Create" in the left-hand menu and choose "Automated cloud flow."
2. Choose Your Trigger: This is the event that will start your workflow. Give your flow a name (like "Sales Goal Reached Alert"), then in the search box for triggers, type "Power BI" and select the trigger named "When a data-driven alert is triggered." Click "Create."
3. Select Your Alert: In the trigger step, you'll see a dropdown menu for "Alert ID." Select the alert you just created in Power BI. Its name should appear in the list.
4. Add the Email Action: Click "+ New step." You need to add an action that sends an email. Search for "Office 365 Outlook" and select the action named "Send an email (V2)."
5. Compose Your Email with Dynamic Content: This is where the magic happens. Instead of writing a static email, you can pull in live data from the Power BI alert. In the "Send an email" action fields, you'll see a "Dynamic content" panel appear.
6. Save and Test Your Flow: Once you're done, click "Save." Your workflow is now live! The next time your data in Power BI crosses the threshold you set, this flow will run automatically and send your perfectly formatted email.

Going Further: Adding Conditions and Customizations

Power Automate lets you build much more than just simple email alerts. You can add conditional logic to create workflows that are far more intelligent.

For example, after your Power BI trigger, you could add a "Condition" control. You could configure it like this:

• If the Tile Value is greater than 10,000...

This allows you to customize the audience and message based on the magnitude of the data change, making your notifications far more relevant and actionable for everyone involved.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Final Thoughts

Automating notifications turns your data into action. For regular, scheduled reports, Power BI subscriptions are a quick and easy solution. When you need to send immediate, powerful alerts based on real-time data conditions, pairing Power BI data alerts with a Power Automate flow gives you complete control and flexibility.

When we built Graphed, our goal was to make getting insights like these even more straightforward. While Power BI and Power Automate are powerful, setting them up can require learning multiple tools and getting all the settings right. We made it possible to connect your marketing and sales data sources in seconds and simply ask questions in plain English. You can build dashboards and see insights in real-time without the steep learning curve, empowering your team to get answers faster and spend more time making decisions instead of tinkering with configurations.