Hi,
Yes you can acheive this using Microsoft’s Power Automate.
Microsoft Automate is used to manage and automate email marketing activities, including sending marketing emails, automated messages and targeted campaigns. Please check the below link for more details:
https://us.flow.microsoft.com/en-us/connectors/shared_mailchimp/mailchimp/
Using Power Automate, you can send an email when a Power BI data alert is triggered. Also notify relevant people when a Power BI data alert fires without you having to manually let them know. Anyone can sign up for 90 days free trial.