Forum Discussion
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 connections) or when it fails (there is an option to send an email if a SCHEDULED refresh fails). However I cannot figure out how to send an email notification upon the successfull completion of a dataset refresh.
Ideally I would create a Powerflow that detects when a dataset has refreshed and sends an email notification to my team. I have experimented with using Power BI Goals and KPI alerts which key off a datastamp, but so far I have hit a brick wall. Does anyone have a suggestion on how I might accomplish this?
thanks,
Bryon
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
5 Replies
Hello
Looking for a solution to this issue I came across this post. I have not been able to solve it with what is indicated. However, I have come up with a solution. Somewhat laborious, but it works.
1) I create a measure in my report that returns some numeric value that changes on update (in my case I have converted the last data date to a numeric value. For example: 20240101. But it could be a COUNT of the number of records or any other numeric value)
2) I create a card in the report with the measure (if you don't want it to be visible, put it on a hidden sheet, for example, but make sure you can access that card from the Power BI service at least the first time)
3) Additionally, in the Power BI service, I create a goal on a scorecard with reference to this visual of my report
4) On the other hand, I create a Power Automate flow with the trigger "When a power bi goal change" in which I add the step for send the email. As you might guess, the flow is only triggered when the dataset has been successfully updated, since it causes the change in the goal
I hope you find it helpful
Hi, thanks for sharing the solution. May I know how you set the goals value?
Hi , you can find info about scorecards here: Create scorecards and manual metrics - Power BI | Microsoft Learn
Notice that you will need a Connected metric. Here explains how to do this: Create connected metrics in Power BI - Power BI | Microsoft Learn
I hope it is useful to you
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.
