Forum Discussion

ZeinebDerbel's avatar
ZeinebDerbel
Frequent Visitor
5 years ago
Solved

Dataset Refresh taking too long

Hi,   I have multiple Datasets' refreshes that are taking way too long (3 to 4 hours). Refresh average is 12min for each of my datasets, so this is a first in my case.    Is there a way to stop ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    ZeinebDerbel  This is now possible in Power BI Service to cancel a refresh.

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

Hi ZeinebDerbel ，

 

The reason for refreshing taking too much time：

 

Too many datasets to refresh at the same time occupy CPU and memory, Insufficient gateway or underlying data source performance (busy on network / refresh), To refresh the model to be loaded into memory, it takes up 2 times the size of the data set, and you need to wait for memory resources.

 

You need to scheduled the refresh of dataset at different time.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai

  • Drunken_Sailor's avatar
    Drunken_Sailor
    Frequent Visitor
    2 years ago

    Hi, 
    That could be part of it. But What I dont get it when I have a SP list with only 1 row of data and it can take up to 15 minutes to refresh sometimes.  
    Sometimes I cancell it after a frew minutes and restart it and then it refreshes in a couple of seconds.

    I dont have other refreshes going on wither. And if I do its not much data.