Forum Discussion
Refresh Power BI Dataset using Power Automate
Oh sorry. I forget that the power automate doesn't have all the requests from power bi rest api. You could do two things:
- Run an http request to power bi rest api to get that info like this link: https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/get-refresh-history-in-group
- The alternative would be creating a table inside the dataset that has the datetime of the refresh. A table that has only one column and one value. Something like DateTime.LocalNow(). Once that's in the model. At Automate Create a variable with the datetime before running the refresh. After running the refresh, you can "Run a query against a dataset". Use DAX to get the value of that table of one row and one column. If the date is after the refresh was run, then it has finnished successfully. You might need a break by time know how long the refresh usually last because if it fails, the condition of checking if the date is older than the one in the query will never match.
I hope that helps
If the flow is what is failing as opposed to the refresh, what you are looking for is the send an email connector, and set it to only runif the previous step has failed.
This doesn't work because the node in Power Automate return successful status when it successfully send the request for the semantic to refresh, not when the semantic model successfully refreshed. So if there's an error and the Power BI semantic model didn't refresh, it won't reflect that in Power Automate.