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.
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.
Good morning v-henryk-mstf ,
Let me be clear of what I have done this far and what I am trying to do.
Response Question: If I publish these 11 queries to the service, then that will not be evaluating the automatic refresh times which I have set up inside the excel power queries themselves. But, rather It will be evaluating the refresh time the Excel Queries are refreshing to the Service. Do you agree? Or have I misunderstood your solution?
Some Background of what I have done this far.
1.) I have created 11 queries through excel power query, because I wanted to divide up the data processing efforts to transform a total of 500,000 records. So instead of 1/2 a million records to process at one time. I am processing roughly 45K records
2.) Next Step: I am appending those 11 queries into a .pbix document and creating my visuals.
After that I am bringing these queries into my .pbix file and appending the files and adding one more transform and several other calculated columns.
My Intention: To evaluate the refresh time for the Excel Power Queries by leveraging some Microsoft Esque solution of which I have not identified.
I have identifed several Refresh Solutions from a Guy In a Cube such as
OneDrive/Share Point
Schedule Refresh
On Demand
Power Shell (On Demand)
and now I am reviewing Microsoft Flow.
Thank you for your effort in trying to help me come up with a solution,
Chris