Send Email Based on Number

[jonboylib]

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?

[arvindsingh802 · Accepted solution]

You can refer Set data alerts in the Power BI service - Power BI | Microsoft Docs

Power BI Alerts with Microsoft Flow: Set Power BI to Send Email Notifications | Stoneridge Software