Forum Discussion

gmd_23's avatar
gmd_23
Frequent Visitor
5 years ago
Solved

Dataset refresh failures - recent issue

Hi,   Is anyonwe else facing multiple dataset filaures on previously working datasets. Problem occurs regardless of datasource, size, complexity of query etc. This occuring since late 3rd Feb. Same...
General Comment
Need Help
  • nickyvv's avatar
    nickyvv
    5 years ago

    Hi gmd_23,

    You could try enabling Premium Gen 2 on your capacity, that will for sure get rid of any concurrency or memory refresh problem. Do remember that it is in preview, and that you will not have refresh metrics in the Premium Capacity App anymore. Have a look at all the current limitations.

    But you can always switch back if it doesn't solve your problems.

     

    If that doesn't help, I suggest you create a support ticket (which is free with a Pro license). Go to the support page to file a support ticket.

v-cazheng-msft's avatar
v-cazheng-msft
Community Support
5 years ago

Hi, gmd_23 

According to the error message you provided, this issue is caused by exceeding the memory limit. The size of the datasets will grow multiply when refreshing. And If multiple datasets need refresh at the same time, they will competing for memory resources. If the memory is insufficient, even if there is only one model in the capacity, data refresh will not complete.

 

You can try these steps to solve this problem

1 Reduce the number of datasets refreshed concurrently

2 If the capacity is Premium capacity, analyze the refresh history and metrics related with refresh to find the datasets needing optimizing, including removing data unused and reducing queries

3 Scale up the capacity if necessary

 

You can also refer Why are data refreshes not completing.

 

Best Regards,

Caiyun Zheng

 

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.