Subscribe issues from BI service

Hi,

I put a subscription report page from Power BI service to user twice a day, one is morning at 10 clock and another one is evening at 5 clock.
Sometimes the report take a while to refresh the data set either morning or afternoon meanwhile the Power Bi service send a automatic email notifications to user during the data set refresh in progress mode so the user has old data visualisation in report page at the point of time.

My question is how can I avoid this situation and is there any alternative way to do it?

I want setup the automatic email notification to user once data set is completely refreshed?

Is that possible to achieve my requirements in power automate by using automatic cloud flow?

Could you please advise and Share the relevant article so I could refer it.

Thank you.