Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
tamiribas
Helper II
Helper II

Sending data driven alerts from a power BI report

Hello,

I have a simple report with a single table in it.

 

Account NameAccount ManagerAccount Manager Email%Utilization
Account1Tamirtamir@company.com80%
Account2Nadavnadav@company.com91%
Account3Nadavnadav@company.com85%

 

As soon as the [%Utilization] measure exceeds the value of 90%, I would like the Account Manager to get an email alert with atable that shows only the rows that contain his/her associated records.

 

I need the alert to be triggered by the [%Utilization] measure and not by a planned schedule.

 

Thank you,

Tamir

 

 

6 REPLIES 6
tamiribas
Helper II
Helper II

tamiribas_0-1708519652017.png

I can set a threshold...but cannot send it to the associated Account Manager. 

The "send to" field, can accept only hard-coded emails, not a parameter.

Any advise?

 

Thank you,

Tamir

Ritaf1983
Super User
Super User

Hi @tamiribas 
Power BI has the functionality of alerts with specific visuals like cards/gauges.
If it can help to achieve your goal, please refer to the linked documentation:
https://learn.microsoft.com/en-us/power-bi/create-reports/service-set-data-alerts

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

 

@Ritaf1983 

I am looking for a solution that supports a table visual and is supporting the scenario I've mentioned.

Your reference, I believe to be for another scenario.

Thanks,

Tamir

The other option is a Data activator, which is in preview .

To use it you should have a fabric capacity and use this from the fabric workspace.

https://learn.microsoft.com/en-us/fabric/data-activator/data-activator-tutorial

These are all the options for alerts that we have in Power BI.

 

From what I've seen, Data Activator can be triggered by schedule only and not by a threshold of a measure as in a dashboard alert

@tamiribas 
Refer to the 4-6 steps in the tutorial that I linked

Ritaf1983_0-1708174962510.png

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.