Yes, you can add a condition to your Power Automate flow to check if the data refresh was successful before sending the email with the Power BI report.
Here's an example of how you can do this:
- Add a "Recurrence" trigger to your Power Automate flow to run daily.
- Add an action to the flow to get the refresh history of the dataset from the Power BI API. You can use the "HTTP" action and call the "Get Refresh History In Group" API endpoint. You will need to provide the Group ID and Dataset ID for your Power BI report in the request URL.
- Parse the response from the API using the "Parse JSON" action to extract the status of the last refresh.
- Use a condition action to check if the status of the last refresh is "Succeeded". If it is not, then you can end the flow without sending the email.
- If the refresh was successful, then add the actions to download the PNG attachment and send the email with the report as you currently have in your flow.
Here's a sample JSON schema for the response from the Power BI API that you can use in the "Parse JSON" action:
{
"type": "array",
"items": {
"type": "object",
"properties": {
"id": { "type": "string" },
"startTime": { "type": "string" },
"endTime": { "type": "string" },
"status": { "type": "string" }
},
"required": ["id", "startTime", "endTime", "status"]
}
}
You can use the "status" property to check if the last refresh was successful.
