Send Email Based on Number

Hi,

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?