Using Power Automate? Using Power BI? Why not put the two together for some interesting scenarios. Patrick uses the Power Automate visual, in a Power BI report, to send emails out.
Power Automate:
https://flow.microsoft.com/
Blog Announcement:
https://powerbi.microsoft.com/en-us/blog/announcing-the-new-power-automate-visual-for-power-bi-reports/
Documentation:
https://docs.microsoft.com/power-bi/create-reports/power-bi-automate-visual