Forum Discussion
MailOnCompletion don´t work in dataflow refreshes
When I refresh a dataflow with Power BI API including in body { "notifyOption": "MailOnCompletition" } or { "notifyOption": "MailOnFailure" } don´t receive the notification via email with dataflow refresh end.
However that same procedure works correctly when I refresh dataset via API Power BI
6 Replies
For all interested Microsoft has just released some new preview connectors for Power Automate so you can now create flows that address this problem.
Currently there are two connectors, a trigger "When a dataflow refresh completes" and an action "Refresh a dataflow" both very useful. I've already used tested it to daisy chain my dataflow to dataset refreshes.
Yes, indeed this has been announced recently and is the best way. I have already tested it and used it successfully in my updates
Hi FranMullor_Quol ,
Unfortunately, I can't reproduce your issue.
You can create a support ticket for further help.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.I don't think it's a support issue.
The power bi API documentation clearly states that you can receive notifications with a sentence in the body of the request.
However, this notification is not received when it is a dataflow and if it is received when the request is also included in the refresh of a dataset.
https://docs.microsoft.com/en-us/rest/api/power-bi/dataflows/refreshdataflow
Apologies for reviving an old thread but was there solution found to this? I'm not receiving completion notifications either.
I want to set up a power automate flow that will automatically refresh a dataset when the dataflow refresh finishes but without an email I have no way to set an accurate trigger (at the moment I'm using a delay of the estimated datflow refresh time in my flow)
There is no solution for sending but if there is already an endpoint that can be attacked with power shell to get after the completion of the update of the dataflow directly run the update of dependent datasets.
In addition to Power Shell I have managed to automate this process in power bi by creating a dataset that calls power shell with an R.
I have it documented in my blog but it is in Spanish
Automatización de las actualizaciones de dataflows y datasets - (powerbisp.com)
