Hello,
In Power Automate, I have created a flow where the flow triggers at the scheduled time and will refresh the Power BI dashboard and then sends an email to the list of recipients via outlook (Success email for success and Failure email for failure). However, send an email trigger is not waiting for the dashboard refresh status whether the refresh is success or failure. It is automatically sending success email as soon as dashboard refresh is initiated. How do we fix this issue in Power Automate flow ?
I have tried adding "Delay" action after "Refresh a Dataset" action but still facing the same issue.
Is there a way in Power Automate flow where we can get the refresh history of a dataset and then send an email to the recipients based on the refresh status ?
Thanks in Advance.