Alert or email triggered by table value

[anderb]

Hello

I have developed a report to monitor system parameters. If any of the parameters change, I need some sort of notification or alert. So I have two questions:

1. Is Power BI capable of automatically generating an email if a value in a table changes. That is - I have a column where if the value is anything greater than 0.00, I would like an email to be sent.

2.  Is it possible for an alert to be generated if a table value changes. As above, if the column value is greater than 0.00, an alert is triggered.

Thank you in advance

[Migasuke]

Hi @anderb ,

you can't use tables for your notifications but you can use dashboard and tiles. There is possibility to set up power automate flow, which can send any kinds of notifications.

Details are here:

https://learn.microsoft.com/en-us/power-bi/create-reports/service-set-data-alerts

[anderb]

Thanks for you response @Migasuke .  I'm surprised some sort of alert or notification can't be generated from a table value.

Alternativly - is it possible to highlight a linked slicer based on a change in cell value?

Thank you

[Migasuke]

Hi,
how should it work? I am not sure if I get it.

[anderb]

Hopefully the screenshot below explains it a little better. So as an example:

If the value in the AvgDespatch column is greater than 5, highlight the associated country in the slicer.

[Migasuke · Accepted solution]

I am affraid this is not possible.
There might be an workaround, but it's bit advanced:
1. You might create Power Automate flow, which queries the data and basically "replicate" the table you have above.
2. You set up a condition in your flow. Something like IF Albania >5, THEN xxx
3. You set up action, which would be notification.

I think the basic idea can be understood from the following video:
https://www.youtube.com/watch?v=WUSo5GLV6uk&t=1s&ab_channel=Curbal