Forum Discussion
Receive email alert when visual reaches certain data point
You can set up data driven alerts against visuals displayed in a dashboard (Set data alerts in the Power BI service - Power BI | Microsoft Docs). IMO this feature is half-baked and really only has limited use cases. I'm not a fan.
You can also use Power Automate to expand the list of recipients based on a Power BI alert (Integrate Power BI data alerts with Power Automate - Power BI | Microsoft Docs) - again, this is limited to dashboards only.
A more flexible approach using Power Automate might involve running a DAX query against your dataset in PA using the Power BI API to get the value from your dataset that you want to trigger against. You can then use PA to send emails, SMS, etc.
Finally, there's a third party solution called Power BI Report Scheduler. In addition to creating and managing report subscriptions, there's also a trigger function built into the software (Power BI Report Scheduler & SSRS Distribution with PBRS (christiansteven.com))
Hope this helps!