Is there any way to give an alert if my data flow is refreshing from more than 30 min

[srikanthorigin]

Hi,

Is there any way to give an alert/send a email to user if a datflow is taking longer than 30 min to refresh.

[srikanthorigin]

Yes! it is scheduled to run every 30 min. 
There are some situations where the data flow is running for almost 15 hours it is neither cancelled or Completed. So we want to give an alert to the user if it is refreshing (more than 30 min)

[NandanHegde]

Hey,

Based on my knowlegde, there is no direct out of box functionality for that kind of support/alert.

You would have to write a custom logic for the same.

Sample: https://datasharkx.wordpress.com/2022/11/07/refresh-power-bi-dataflow-dataset-from-azure-data-factor...

So the flow would be as below:

1) Trigger the dataflow refresh via REST API

2) SInce it is an async call, keep checking the status of refresh till success/failure and add a condition if the wait time is greater than 30 , send an email notifcation (a custom alert)

[srikanthorigin]

I know we can track the status using power automate wether it is success or failed. But i want to give an alrert if the data flow is running more than 30 min or so

[NandanHegde]

Hey, Is the dataflow being triggered via any job or via scheduled run?