Power Platform Community Forum Thread Details

Hi Team,

I’m currently building an auto-refresh process for my semantic model, and as part of that, I’d like to include a notification in case the refresh fails.

I’ve already configured the "Run After" settings, but I didn’t receive any notification when the semantic model refresh failed.

After investigating, I found that the "Run After" configuration only checks whether the refresh dataset step was successful—it doesn’t validate the actual refresh status from the Power BI workspace.

This behavior is similar to Dataflows, but unlike semantic models, Dataflows have a trigger that can detect when a refresh is completed.

I’m hoping to get some guidance or suggestions on how to handle this scenario. Thank you in advance for your help!

Best regards,

Categories:

Building flows

@Dexter Asuncion

You're absolutely right in observing that the "Run After" configuration in Power Automate only checks whether the refresh request was successfully sent, not whether the semantic model actually refreshed successfully. This is a known limitation when working with Power BI semantic models.

✅ Recommended Solution: Use Power BI REST API to Check Refresh Status

To reliably detect whether a semantic model refresh succeeded or failed, you can use the Power BI REST API:

🔹 Step 1: Trigger the Refresh

Use the POST /refreshes endpoint:

POST https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/{datasetId}/refreshes

This initiates the refresh asynchronously.

🔹 Step 2: Poll for Refresh Status

Use the GET /refreshes endpoint to check the status:

GET https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/{datasetId}/refreshes?$top=1

This returns the latest refresh attempt, including:

status: Completed, Failed, or Unknown
startTime, endTime
serviceExceptionJson (if failed)

You can then use a condition in Power Automate to send a notification if the status is "Failed".

🛠️ How to Implement in Power Automate

Trigger the refresh using HTTP action.
Wait/pause for a few minutes using Delay action.
Call the GET refresh status API.
Parse the response using Parse JSON.
Add a condition:
- If status = "Failed" → Send email notification.
- Else → Continue or log success.