Receive Power BI dataset Refresh failure notification when the refresh is not a scheduled refresh

We've been trying to do the same thing. This option is not really that great. It seems there is no straight forward way of getting a failure notification for a dataset refreshed by Power Automate. The email option in Power Automate only informs if the action of setting off the refresh itself fails, not if actual refresh fails after being set off.

Only option I have found that might help is to subscribe to the report itself and get a notification if data is updated or not. But that is a daily mail whether successful or not, so a bit overkill (well for our needs anyway)

Maybe this can be a development idea in Power Automate, an actual simple step that can check refresh state after it has been initiated with option to send email alert on status, for all or only failed items?