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

Requirement: We are required to set up a Power automate flow to trigger Power BI data refresh when an email arrives and get a Notification if the refresh is unsuccessful. We have created the flow t...