Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
ZeinebDerbel
Frequent Visitor

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 or cancel a refresh? 

 

Any help would be appreciated.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

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

v-deddai1-msft
Community Support
Community Support

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

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.

Anonymous
Not applicable

@ZeinebDerbel 

You can disable the scheduled refresh under settings pane.

Schedule refresh

 

Appreciate your kudos!! Mark this post as solution if this helps you.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.