How to Set Alerts in Power BI

Staying on top of your key business metrics can feel like a full-time job. With alerts in Power BI, you can stop constantly checking your dashboards and let real-time notifications tell you when a number needs your attention. This tutorial walks you through exactly how to set up, manage, and get the most out of data alerts in Power BI.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What Are Data Alerts in Power BI?

Data alerts are a feature in the Power BI service that automatically notifies you when data in one of your dashboard visuals crosses a specific threshold you've set. In simple terms, you can tell Power BI, "Hey, email me if our daily sales drop below $10,000," or "Let me know when website traffic for the hour goes above 5,000 visitors."

This transforms your dashboard from a passive reporting tool you have to remember to check into a proactive monitoring system. Instead of discovering an issue hours or days later, you get notified almost immediately, allowing you to take action when it matters most.

Alerts can be sent directly to your Power BI Notification Center and, optionally, to your email address. It's important to know that currently, only three types of visuals support alerts:

• Card visuals: Perfect for single, important numbers like total revenue or new leads.
• Gauge visuals: Ideal for tracking progress toward a goal, like quota attainment.
• KPI visuals: Used for measuring performance against a target value.

When an alert is triggered, Power BI sends a notification only to you - the person who created it. You can't set an alert in Power BI and have it automatically go to your entire team. However, you can use these alerts to trigger other actions, which we'll cover later.

Prerequisites: What You Need to Set an Alert

Before you jump in, you’ll save yourself a lot of frustration by making sure you have a few things in place. If you're struggling to find the alert option, it's likely due to one of these common requirements.

1. A Power BI Pro or Premium License

Data alerts are not available for users with a Power BI free license. You'll need a Pro or a Premium Per User (PPU) license to create and receive alerts. If you work at an organization that uses Power BI Premium capacity, you can also access this feature.

Graphed

Still Building Reports Manually?

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

Watch the Demo

2. Your Visual Must Be on a Dashboard

This is the most common reason people can't find the alert option. Alerts can only be set on visual tiles on a dashboard, not on visuals within a report. A Power BI report is the multi-page canvas where you build your visuals, while a dashboard is a single-page view containing tiles pinned from one or more reports. You must first "pin" your Card, KPI, or Gauge visual from the report to a dashboard to enable the alert functionality.

3. It Must Be a Supported Visual Type

We mentioned this above, but it's worth repeating: you can only set alerts on Cards, Gauges, and KPIs. If you try to set an alert on a bar chart, line chart, or map, the option won't be there. The visual must display a single, queryable number.

4. The Data Must Be Refreshed

Power BI only checks for alerts when the underlying dataset is refreshed. If your data is on a daily refresh schedule, Power BI will only check if your threshold has been crossed once a day, right after that refresh completes. It doesn't monitor the data in true "real-time" every single second. Keep this in mind when you set your notification frequency.

Step-by-Step Guide: How to Set an Alert in Power BI

Once you’ve met the prerequisites, creating an alert is straightforward. Follow these steps to set up your first one.

Step 1: Open Your Dashboard and Find Your Visual

Navigate to the Power BI workspace that contains your published reports and dashboards. Open the dashboard where you've pinned the Card, Gauge, or KPI visual you want to monitor. For this example, let's say we have a simple Card visual showing the total number of "Daily Online Orders."

Step 2: Access the Alert Management Pane

Hover over the dashboard tile. In the top-right corner, you’ll see an ellipsis button (...). Click it to open a menu of options, then select Manage alerts.

Step 3: Add a New Alert Rule

This will open the "Manage alerts" pane on the right side of your screen. Click the blue button that says + Add alert rule. If you already have alerts on this visual, they will be listed here.

Step 4: Configure Your Alert's Conditions

Now it's time to define the logic for your notification. You'll have several fields to configure:

• Active: This toggle is on by default. You can use it to temporarily disable the alert without deleting it.
• Title: By default, this is pre-filled with a generic title. It's a good idea to rename it to something descriptive, like "Alert: Daily Orders Dropped Below 150." This title will appear in the notification email subject and body.
• Condition: This is the core logic. You have two choices: Above or Below. Choose "Above" if you want to be notified when the value surpasses a number (e.g., website bounce rate exceeds 70%). Choose "Below" if you want to be notified when the value drops under a number (e.g., inventory stock falls below 20 units).
• Threshold: This is the numerical value that triggers the alert. Enter the number that matters to you. For instance, if you want an alert when orders drop below 150, you would set the Condition to "Below" and the Threshold to 150.
• Frequency: This controls how often you receive a notification once the condition is met. The options are "At most every 24 hours" and "At most once an hour." This prevents you from getting spammed if the value hovers just above and below the threshold between frequent refreshes. "At most once an hour" is great for mission-critical metrics tied to data that refreshes frequently.
• Send me an email too: In addition to alerts in your Notification Center, checking this box will have Power BI send you an email. The email will contain the details and a direct link to the dashboard tile.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 5: Save Your Alert

Once you're happy with your configuration, click Save and close at the bottom of the pane. You're all set! Power BI will now monitor that metric and notify you the next time your data is refreshed and the condition is met.

Managing and Editing Your Alerts

Your business priorities change, so your alerts will need to adapt. Managing them is just as easy as setting them up.

How to Edit an Alert

To edit an existing alert, go back to the dashboard tile, click the ellipsis (...), and select Manage alerts. You'll see your existing alert rules listed. Simply click on the alert title to reopen the configuration pane. You can change the threshold, condition, frequency, or email preference. A bell icon with a number next to it on the tile indicates how many active alerts are set for that visual.

Turning an Alert On or Off

If you want to pause an alert without deleting the rule entirely, just use the On/Off toggle next to the alert name in the "Manage alerts" pane. This is useful for temporary situations, like disabling a sales alert during a planned holiday promotion where numbers will be unusual.

Deleting an Alert

If an alert is no longer relevant, you can permanently delete it by clicking the trash can icon next to its name in the "Manage alerts" pane.

Best Practices and Pro Tips for Alerts

Setting up alerts is easy, but using them effectively requires a bit of strategy. Here are a few tips to make your alerts more impactful.

1. Focus on Actionable Metrics

Don't just set alerts on every KPI you have. Ask yourself: "If this number changes, will I do something about it?" Set up alerts on metrics that are tied directly to business actions. For example, an alert that "Inventory Levels for Product X are critically low" is much more actionable than one that says "Website Pageviews are slightly up." You want alerts that trigger decisions, not just observations.

2. Avoid Alert Fatigue

If you're getting bombarded with a dozen notifications every day, you'll eventually start ignoring them all - including the important ones. Be selective. Only set alerts for truly exceptional events, positive or negative. For values that fluctuate normally, consider creating a visual in your report that highlights tolerable ranges instead of setting an alert.

Graphed

Still Building Reports Manually?

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

Watch the Demo

3. For More Power, Connect Alerts to Power Automate

This is where things get really interesting for more advanced users. You can use Power BI alerts as triggers for workflows in Microsoft Power Automate (formerly Microsoft Flow). This allows you to notify more than just yourself.

• Here's a powerful example:

You could create an automated workflow where a Power BI alert (e.g., "Daily Registrations Below 10") triggers an action and sends a message with details directly to a specific Microsoft Teams channel for your growth team to act upon and mitigate.

This bridges the gap between personal notification and team-wide action, making alerts a much more collaborative tool.

Remember Why You Set the Alert in the First Place

The alert tells you what happened, but the email notification will only provide you so much context. Click the direct link on the email notification to jump directly from the email into your dashboard so you can dig deeper into related reports to explore why the number changed. This allows you to move quickly from identifying a problem to diagnosing its cause.

Final Thoughts

Power BI alerts are a simple, powerful feature for anyone looking to move from passively viewing data to proactively monitoring it. They help you stay on top of your critical business metrics, saving you from having to constantly check your dashboards and enabling you to take action faster and keep your goals on track. While setting alerts within a platform like Power BI is a great step, true data-driven autonomy comes from the ability to connect and understand all of your data sources smoothly. This is where Graphed can help. Instantly connect your sources like Shopify, Google Analytics, Facebook Ads, and HubSpot all in one place. Instead of manually building your dashboard in Power BI, you can ask it a natural language question like "Show me a dashboard comparing Facebook ad spend and revenue by campaign," and Graphed builds it for you in seconds. It's like having a full-time data analyst who keeps you informed about your entire business, not just one part of it, without the need to learn any technical software.