Forum Discussion
Dataset Refresh Timeout Help!
Hi lrobb ,
In my experience, when the refresh times out it's because one or more of the queries are running slowly and causing a hold up for other queries.
It could be possible that when you refresh the data in Power BI Desktop on your local machine, some of the information for the refresh is stored in your local cache. And when you refresh it in your Power BI Service, this is not the case and hence it probably takes longer and results in timing out.Without more information on your requirement here are some of my recommendations for your issue:
* You can clear the cache in the Options settings of your Power BI file.
* You can also increase the amount of RAM allocated to allow more data to be loaded.
* You can schedule the refresh at a time when the server may have more bandwidth to run the query.
* I would suggest optimizing your queries, deleting any fields that are "heavy" and not needed.
Sometimes when loading from web sources like Odata, the queries load data row after row which can be slow running and cause issues during refresh.
You can install awesome external tools like the Tabular Editor, DAX studio to deep dive into your queries and fields. How To Install DAX Studio & Tabular Editor In Power BI - Enterprise DNA
Power BI's Query analyzer is also great at analyzing slow running queries.Hope this helps, please reply with more information about your issue so we can understand your issue better. Thanks!
Hi lrobb ,
In my experience, when the refresh times out it's because one or more of the queries are running slowly and causing a hold up for other queries.
It could be possible that when you refresh the data in Power BI Desktop on your local machine, some of the information for the refresh is stored in your local cache. And when you refresh it in your Power BI Service, this is not the case and hence it probably takes longer and results in timing out.
Without more information on your requirement here are some of my recommendations for your issue:
* You can clear the cache in the Options settings of your Power BI file.
* You can also increase the amount of RAM allocated to allow more data to be loaded.
* You can schedule the refresh at a time when the server may have more bandwidth to run the query.
* I would suggest optimizing your queries, deleting any fields that are "heavy" and not needed.
Sometimes when loading from web sources like Odata, the queries load data row after row which can be slow running and cause issues during refresh.
You can install awesome external tools like the Tabular Editor, DAX studio to deep dive into your queries and fields. How To Install DAX Studio & Tabular Editor In Power BI - Enterprise DNA
Power BI's Query analyzer is also great at analyzing slow running queries.
Hope this helps, please reply with more information about your issue so we can understand your issue better. Thanks!
I was able to figure it out. There is an operation I'm performing which (not surprisingly) caused an issue. I had a visual which required too much RAM to load, so I pushed it to a calculated table, however, this also failed the refresh for the same reason.
Hi lrobb , There's a setting in PBI Desktop where you can increase the RAM / cache memory used by the PBi file.
Go to Options of your PBix file. And find the Cache memory option and change it to maximum available on your laptop / machine.
