Forum Discussion
Error on cancelling refreshes
I have a dataset that has two refreshes simultaneously and when i try to cancel the refresh from the service i had this error:
And from the history of refresh i have this two refreshes that says:
So i have a refresh that is looped and the another refresh that say "cancelling" but is not cancelling, it's looped too.
So the dataset is blocked, i can't refresh it and i can't cancel the refresh.
Hi Gdaros_95,
The Power BI Refresh does get stuck sometimes when canceling. It should timeout in some time, but you should first turn off any scheduled refreshes, to prevent another refresh from getting triggered.
You can also use the Power BI API to cancel the refresh. but most likely you won't require it - https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/cancel-refresh-in-group
If none of the above works, consider contacting Microsoft Power BI Support.
Hi Gdaros_95 ,
Due to the design of Power BI service, refresh in Power BI service is slower than in Power BI Desktop. When there are not enough resources, the dataset enters the waiting queue, which can cause latency issues. You need to avoid frequent operations on the dataset at a certain time or reasonably plan the refresh time of the dataset to avoid peaks.
If the data set refresh has stalled, you can try Cancel Refresh REST APIs to cancel the refresh and restart.
Datasets - Cancel Refresh - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Datasets - Cancel Refresh In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Best regards,
Mengmeg Li
2 Replies
- Bipin-Lala
Solution Sage
Hi Gdaros_95,
The Power BI Refresh does get stuck sometimes when canceling. It should timeout in some time, but you should first turn off any scheduled refreshes, to prevent another refresh from getting triggered.
You can also use the Power BI API to cancel the refresh. but most likely you won't require it - https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/cancel-refresh-in-group
If none of the above works, consider contacting Microsoft Power BI Support.
Hi Gdaros_95 ,
Due to the design of Power BI service, refresh in Power BI service is slower than in Power BI Desktop. When there are not enough resources, the dataset enters the waiting queue, which can cause latency issues. You need to avoid frequent operations on the dataset at a certain time or reasonably plan the refresh time of the dataset to avoid peaks.
If the data set refresh has stalled, you can try Cancel Refresh REST APIs to cancel the refresh and restart.
Datasets - Cancel Refresh - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Datasets - Cancel Refresh In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Best regards,
Mengmeg Li