cancel
Showing results for 
Search instead for 
Did you mean: 

PBI Service Dataset Refresh Hanging for Hours

This has been a longstanding, intermittent problem that has become a critical issue as of late. Many times, simply performing a manual dataset refresh takes hours for the same dataset that typically takes seconds. The source type (e.g. SQL, D365, etc.) does not seem to matter because it appears to occur regardless.

The most critical aspect of this issue is the user's inability to manually stop a running refresh. Instead, the user is forced to wait until it finishes, which many times takes hours.

Please advise.

Refresh in progress
A refresh is in progress. Please wait for the current refresh to finish before clicking Refresh Now.
Please try again later or contact support. If you contact support, please provide these details.
Activity ID9da105ab-60b0-40fd-8d0c-deb339ef2889
Request IDcaba9473-cd45-1364-2130-a370b3bf4e35
Correlation ID6ded0709-5828-70ed-c2cc-2669c8901c94
Status code200
TimeTue Feb 19 2019 10:30:52 GMT-0500 (Eastern Standard Time)
Version13.0.8383.201
Status: New
Comments
Moderator

Hi @dharland ,

 

Does the dataset refresh hang frequently? Is the refresh finished finally? You can go to the Refresh History to find the record for the unusual refresh, find if there is any detail error message. 

 

For your requirement to pause the dataset refresh, you can vote this same idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/34788757-stop-dataset-refresh

 

Best Regards,
Qiuyun Yu