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

[Anonymous]

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 to trigger the refresh via email. But we want to get notified if our refresh is failed.

Tried some online available ideas as below but was not successful:

Using data driven Alert in Power automate:
Created KPI having a measure which returns 1 when Max refresh date = Today(). But this KPI will return 1 tomorrow as well even if the data refresh fails as the KPI was already 1.

Using statusCode in Power automate:
Here we have used below function to fetch the statusCode of the dataset refresh:

actions('Refresh_a_dataset').outputs.statusCode
- But this variable is always returing 202 which means 'the refresh has started and is in progress'

Is there any other way to achieve this requirement?

[Kevin_Brennan]

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?

[ppm1]

Please see this video for one way to do this.

https://www.youtube.com/watch?v=n8qGP2kiZHo&t=518s

Pat