Datasets Refresh Issue - Taking Too Long Lately

[Anonymous]

Hi Everyone,

In the past two weeks, I noticed that it takes a lot longer to refresh the datasets in service (using scheduled refresh) than it used to be. Did anyone else notice this? 

I have a bunch of small databases/reports derived from the small files (.txt, xlsx etc.) that I keep in sharepoint, normally none of them would take longer than 30 mins to refresh, now it takes hours and sometimes i even see timeout errors. 

I looked into incremental refresh etc. but actually my data is not getting bigger since I receive daily data via e-mail and overwrite automatically every day in sharepoint using microsoft flow. 

Even smallest, simplest databases are taking noticably longer to refresh lately.

Any recommendations you may have would be appreciated. 

Thanks in advance. 

[Anonymous]

Hi  @Anonymous ,

Possible causes:

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.

This is the related document, you can view this content:

Dataset scheduled Refresh is taking too long - Microsoft Power BI Community

Solved: Data Refresh in Power BI Service is too Slow - Microsoft Power BI Community

Solved: Updating Data takes a long time - Microsoft Power BI Community

Best Regards,

Liu Yang

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

[Greg_Deckler]

@Anonymous You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

[Anonymous]

Many thanks Greg, did not know there is such a page to follow the common issues 🙂