Forum Discussion
Getting Refresh Failure Notification From Manual Refresh
- 1 year ago
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 HistoryIf 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
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
- junminn301 year agoRegular Visitor
I don't have a premium license for Power Automate. Am I able to use this feature?
- SamsonTruong1 year ago
Super User
Hi junminn30 , this will require a premium license as the HTTP conector for the API call is a premium connector.
- junminn301 year agoRegular Visitor
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