Getting Refresh Failure Notification From Manual Refresh

[junminn30]

Hi, I'm not sure if this is the right forum or not but basically, I created a Power Automate flow to trigger a Power BI dataset refresh and added an action to send email if flow failed. However, I noticed that sometimes the flow is successful but the dataset actually failed to refresh due to error like missing columns in the Excel data source, but I did not receive the usual dataset refresh failure email notifications. I understand this may be because email notifications are only sent if the dataset failed to refresh using a scheduled refresh. But since this is refreshed through Power Automate, it is as if I manually refresh the dataset so no failure notification is sent. 

Could anyone please share what can I do so that I can still use this Flow and receive failure notification?

[SamsonTruong · Accepted solution]

Hi @junminn30 ,

To work around this, you can use the Power BI REST API to check the refresh status after triggering the refresh.

After triggering a Power BI semantic model refresh in your Power Automate flow, you can add a short delay (a few minutes) to allow the refresh to complete. Then, call the API to retrieve the refresh history for the dataset. Once you have the refresh history, use conditional logic to check the status of the latest refresh. If the status is 'Failed', you can add an action to send an email notification.

Here is the official API documentation to retrieve the refresh history: Datasets - Get Refresh History

If this helped, please mark it as the solution so others can benefit too. And if you found it useful, kudos are always appreciated.

Thanks,

Samson

[junminn30]

I don't have a premium license for Power Automate. Am I able to use this feature?

[SamsonTruong]

Hi @junminn30 , this will require a premium license as the HTTP conector for the API call is a premium connector.

[junminn30]

Hi @SamsonTruong do you have alternatives for non premium power automate user? I'm unable to use the solution you provided due to not having a premium license

[SamsonTruong]

Hi @junminn30 , this is currently the only solution I have in mind. However, I will update this thread if another solution is available.