Forum Discussion
Refresh Timeout Error.
Hello team,
Hope you all are doing good. I'm facing a problem of Timed Out error in service. I have a pro account and when I initially refresh the dataset on service, it gives "Timed Out" error after 2 hours. So what are the ways to refresh the data on service?
Thank you for your efforts in advance..
13 Replies
Hi. Power Bi Pro has a limit of 2 hours to refresh your data.if you exceed that time you can't continue. This can happen for different reasons like bandwitdh (if you have a gateway) or dataset size.
You have to consider reading about downsizing data model. You can find amazing youtube videos from guy in a cube and others in order to make your model smaller. Usually making a good star schema helps.
Another thing you can check is if your source is returning the data fast. You might have a big crazy native query to the source that takes a lot. Those scenarios might need a middle store procedure building a table in the data base engine in order to help Power Bi only reading the resulted table and avoiding running a complex query.
If you are on premise you can also check bandwidth but that might be the last option because the first two I have mentioned are the most common issues.
I hope that make sense,
Hi ibarrau , Thank you so much for your reply.
Everything you mentioned makes sense and I have taken care of every point you have mentioned and also the dataset has a large amount of data. Is there any other way by which I can refresh the dataset?
If you are sure you have an amazing star schema connected to a source that runs fast single tables (not native query with logics) and you still have 2 hours limit, then you should consider a different license like PPU (premium per user) or moving dataset to Analysis Services. There is also a premium license. If you are sure you have optimized all then the limit can't be skipped, that's showing you that Pro License is not enought for your model.
I know incremental refresh is now available for Pro, but I'm not sure if that will let you skip this limit. You can try it if you have a DB source with Query folding (SQL server, Synapse, postgress, etc).
I hope that helps,
Is this limitation applied also on power BI server on premise ( which installed on our sql server) ?
Hi,
Apologies if I am brining up an old topic. I am facing a similar issue. How did you manage to resolve yours ?
Hi Uniqueusername ,
In our case the data was significantly big and as the refresh occurs in a shared memory in pro account, we moved towards premium account which gave us a dedicated memory to refresh the report after consulting with Microsoft Support team.
thanks for that. We are on a premium subscription as well. Were you facing the slow refresh times while scheduling auto refresh through the gateway ?
I have been noticing my reports taking a lot longer to refresh for some reason as compared to some of the other reports which are on the same workspace on the gateway. My reports seem to take for hours compared to a forced, on-demand refresh taking a few minutes
The storage mode my model has is a mixed with DirectQuery , dual and import modes
Hoping someone can help with this. Here is a screenshot the number of refresh attempts. As you can the whole process took around 2 hours
