Multiple Alerts in one email

I have read about Zapier in past that it integrates with PowerBI and can do the needful though I have never tried it.

Using Power automate also there is no clean way of doing it. You can add a PowerBI alert trigger and then send the alerts to a sharepoint say so all the alerts will be there and based on timeframe, you can have one more power automate which can fetch data from that sharepoint list and consolidate alerts in a single mail and send that. This second power automate will have to run at specific times only so that it can work properly to combine all alerts.