Forum Discussion
Send email notification when a Power BI Dataset Successfully Refreshes
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
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