Forum Discussion
Solved
Send email notification when a Power BI Dataset Successfully Refreshes
I need to send an email notification when a Power BI dataset successfully updates. There are several different methods of sending email notifications when a dataset refresh begins (using Powerflow co...
Hey BryonScruggs ,
I'm unaware of any bullet-proof solution that creates a message when a dataset refreshes successfully.
Nevertheless, it's one of the things on my bucket list (no planned eta though). I'm experimenting with combining to REST API Calls
- https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/get-refresh-history
- https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/get-refresh-schedule
My thoughts are, get the schedule, if one exists. Get the latest refresh using the additional top parameter.
Merge the two results - done
Hopefully, this provides some ideas on how to tackle your challenge.
Regards,
Tom
Hi TomMartens , thanks for this. I accepted this as a solution although I found a simpler way to accomplish what I need. I used the email notifications from the Power BI subscription service to notify Power Automate when a dataset had been updated.