Forum Discussion
Alert or email triggered by table value
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
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
5 Replies
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
