Alerts for Data Refresh's time in power bi service, if it exceeds more than 30mins.

[Anonymous]

Hi All,
Currently we are facing an issue with Data Refresh's time limits exceeding 4 to 5 hours in power bi service. In order to get notified about if any type of data refresh's exceeds more than 30min then we(org power bi tenant admin team) need to get alerts in the form of an email to take a immediate action, this is to avoid frequesnt capacity overload issues in our tenant.

Any help on how to create the alerts for the above scenario? will be much appriciated. thanks in advance.

[Eduardo_Coelho5]

I'm having the same problem, I have two machines that use Bi premium and they've been updating for hours, even though it doesn't complete the update

[aj1973]

@Eduardo_Coelho5 

My guessing your issue is different. With premium capacity and it takes all that time !!! Not good

[aj1973 · Accepted solution]

Hi @Anonymous 

Are the refreshes going through a Power BI Gateway? If so there is a Template that you guys can use to set alerts.

Or you can use this API
https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/get-refresh-history-in-group

Build a report with this API, create a card with DATEDIFF(StartTime,EndTime) and then Pin the card to a Dashboard to set up alerts. 

[Anonymous]

If I understand this right, this pattern would notify you after a refresh completed or failed of it ran past X minutes.  Is there any way to be notified before it completes?

EX: If it reports normally takes 5 minutes to refresh, If it has been trying for more than 30 minutes, send alert so the refresh can be canceled and tried again. 

[Vinodkumar4466]

 What is the default template, can you please share more details about the template. 

[aj1973]

Here you go

https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-performance

[Anonymous]

Hi @aj1973 ,
Yes mostly all the refreshes are through the Gateways and very few are also using PBI Dataflow refresh also taking lot of time.

[aj1973]

https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-performance

It helps you analyse the performance of you Gateway. from there you can Pin some cards to a Dashbord where you can set up Alerts.

The API I just sent is an other and a good way to achieve it. 

[Anonymous]

Hi,

Thanks for your response!

Actually, we are from "Organization Tenant Admin" team, and we are looking for a solution where we get the information for all the Datasets, Dataflows and Datamarts refresh timings when they exceeds morethan 30min, as we are facing a lot of capacity overload issues due to CPU memory consumption is going high when eever any datarefreshs are going morethan 2 to 3 hours.and we are looking for the alerts mechanism /process for all(tenant level Datasets and dataflows for example: 1000+ datasets we have) to get inthe form of a email or in a PBI report format/template.
Or else is there any way to create a Power automate flow to get notified when the refresh time exceeds for any of the datasets or dataflows in the org tenant level?

[aj1973]

Sorry, It sounds more like you guys didn't understand the 2 solutions i proposed or are not capable in applying them as Tenant Admins.

As far as I know Power automate has not the solution for this. 

[Anonymous]

Hi ,
Thanks for your solutions !! we do understood the process and created a card and pinned as dashboard for getting alerts. its working thanks for the support.!!!