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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
tamiribas
Helper III
Helper III

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 III
Helper III

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.

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

@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.

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

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

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.