it usually takes 1h:15- 1h:30 max for dataset to refeesh. I had to cancel morning refreshes.
and tried to kick in the refresh manually then took longer and cancelled it. now the scheduled refresh is still running for over 4 hours.
3 Comments
v-yanjiang-msftCommunity Support
Status changed:NewtoInvestigatingHi AbcFitness ,
Do you mean the refresh still run even after you have cancelled it? Seems in many cases the Power BI Service will automatically restart the refresh even after you’ve cancelled it. Please try Cancel Refresh rest api call, but only on "enhanced" refreshes, which are started via rest api while adding one or more parameters as per this doc.
Also, see Cancelling Power BI Dataset Refreshes With The Enhanced Refresh API - Chris Webb. The definitive way to cancel a stuck dataset refresh in Primium workspace was described here:
Cancelling a Power BI Premium Dataset Refresh (elegantbi.com)Best regards,
Community Support Team_kalyj
No actually, I was able to cancel the manual refresh. the scheduled refresh I could not cancel, but it took about 5 hours to finish. something odd was hapening, I did another manual refresh at night yesterday and it took about 1h:15 min again which is the normal time it takes usually.
but the issue is back again today for some reason, the refresh is taking too long again:- v-yanjiang-msft
Hi AbcFitness ,
Not sure why you can't cancel the schedule refresh, based on this official document, both schedule and manually refresh can be cancelled. In another document, it said there are two limtations for cancelling refresh: premium capacity and import or composite mode, do your dataset meet the limitations? If you mainly need the manually refresh now, you can temporarily turn off the schedule refresh in dataset settings.
Best regards,
Community Support Team_kalyj