topic Alert or email triggered by table value in Developer

Alert or email triggered by table value

anderb — Wed, 07 Dec 2022 05:52:18 GMT

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

Re: Alert or email triggered by table value

Migasuke — Wed, 07 Dec 2022 06:05:06 GMT

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

Re: Alert or email triggered by table value

anderb — Wed, 07 Dec 2022 20:58:32 GMT

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

Re: Alert or email triggered by table value

Migasuke — Wed, 07 Dec 2022 22:56:01 GMT

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

Re: Alert or email triggered by table value

anderb — Wed, 07 Dec 2022 23:57:22 GMT

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.

Re: Alert or email triggered by table value

Migasuke — Thu, 08 Dec 2022 11:49:04 GMT

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