I have a simple query in PowerBi that retrieves a single figure from a MySQL database. The figure changes frequently, e.g. every minute. So firstly, I need to retrieve this new figure every minute.
If this figure is above a certain amount (e.g. 500), I would like to send an email to various recipients.
Is this possible? If so, how could I achieve this?