Forum Discussion
Calculated Column for Power Query Refresh for Power Automate alert
Hi Csalinas144 ,
It seems that the Power Query does not trigger the sending of the corresponding email when the refresh fails. Why not publish it to service and then configure a scheduled refresh through the gateway. You can check the status of the refresh in the history and set up an email alert to the specified user when the refresh fails.
If the problem is still not resolved, please point it out. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
What part are you still struggling with?
You don't need an entire column for LastRefresh Date/Time - can do this with a custom query, but if your refresh schedule table is small it may work ok. https://www.excelguru.ca/blog/2016/06/08/display-last-refreshed-date-in-power-bi/
You'll need to use DAX to create the Failed/Refreshed column, as if the refresh fails it will not update the Power Query Custom column. I think a simple IF statement should work here, in combo with the TODAY() or https://dax.guide/utcnow/ functions and your calculated columns. Let us know which parts of your question are solved and what you're still struggling with and we can guide with more detailed help.
What's wrong with the built in refresh failure notification emails? https://powerbi.microsoft.com/en-za/blog/sending-refresh-notifications-to-others/
Good Morning AllisonKennedy ,
I am going to try your solution later today after lunch.. I will keep you updated. I appreciate your time and effort to help me on this.
I will keep you updated on my goal.
Thank You,
Chris