Brunner_BI

5. Dez. 20232 Min.

Data alerts in Power BI Reports using Data Activator

Aktualisiert: 6. Dez. 2023

So far, data alerts were not possible natively in Power BI unless when using dashboards. Actually, these kind of alerts were one of the main reasons people used dashboards in the Power BI Service at all.

With Data Activator (which is similar to Power Automate but built into Fabric / Power BI) we can now set data alerts natively in the Power BI Service for reports.

Data Activator must be turned on in the Power BI tenant (admin) settings:

Tenant settings

And it is also only available in these regions.

In the documentation, it actually states that the report where the data alert is set, needs to reside in a Fabric workspace.

However, when testing, it also worked in a Premium capacity workspace.

This is how you can create a data alert:

1) Open a report in the Power BI Service and click on a visual header of your choice and select "Set alert"

Visual header options

Not all visual types are available yet, see this link for the latest visuals included.

As of Dec 5th 2023, the following is available:

Column and bar charts

Ribbon chart

Line

Area

Pie

Donut

Gauge

Card

KPIs

Bing Map

Filled Map

Azure Map

Arc GIS map

2) You will get the menu below to define your data alert

Detailed data alert menu

3) After you created the alert, you will see that there is a new item (a so called reflex item) in your workspace.

Premium workspace content with reflex item

4) When clicking on it, you can update your triggers and actions later on as well.

Detailed configuration of a reflex item in Power BI

5) This is how your alert might look when triggered (besides email alerts, there are also Teams message alerts)

Successfully triggered event in Data Activator - Email

Some things to consider:

Make sure to turn off all notifications before deleting the reflex items.

I just deleted mine without turning them off and now I am still getting notifications but am unable to disable them since the artifacts dont exist anymore.

I hope Microsoft will fix this at some point otherwise I will get a hundred emails a day.

    8520
    2