Forum Discussion
data source timed out , refreshing process failed
I'm facing this issue for 1 week, most of the time the refreshing process failed and takes along time
the CSV files size is not more than 60 MB and my connectivity speed is very good and I'm using personal gateway
\what is my problem please ? any one can help
Before the data import for finished, its data source timed out.
Cluster URI: WABI-WEST-EUROPE-B-PRIMARY-redirect.analysis.windows.net
Activity ID: 5af8ba7b-5d27-48e5-9bce-3daff3b57a7c
Request ID: f49baaac-dd2d-7561-94a4-b8ebc699ff50
Time: 2021-01-07 05:53:57Z
Hi hisham2021 ,
If you are using import mode, the data loading time depends on the following:
- The size, row, column and table of the data model. If there is a complex DAX function to calculate the calculated column and table, it will be stored in the data model and increase a lot of time (you can optimize the model according to this link)
- It may also be related to hardware performance and network performance，network status between pc and datasource, and also the performance of pc which runs the power bi
In addition, if it is not the data set of the premium workspace, the refresh time is 2 hours, but the data set of the premium workspace, and the timeout is increased to five hours
There are also related documents that can optimize the data model and reduce the loading time and the possibility of similar problems:
https://docs.microsoft.com/en-us/power-bi/guidance/import-modeling-data-reduction
https://community.powerbi.com/t5/Service/Refresh-Failing-Timeout/td-p/331492
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.
3 Replies
Hi. Power Bi has a 2 hours window to refresh data before timeout. That time is not only for uploading the data. The model itself has a size and it's queries can take time. I'll leave here 5 practises that can help you reducing the "model size" that might improve the refresh time.
https://blog.ladataweb.com.ar/post/614108758904389632/datamodeling-5-tips-de-reducción-de-tamaño-de
You can also find things like this from guyinacube youtube channel.
Hope this helps,
Thanks, ibarrau for the Hint.
but some times it is refreshing successfully and other times not. this is also meaning that I have performance issues in my model?
I also go to the site which you mention above but it's not in English.
Hi hisham2021 ,
If you are using import mode, the data loading time depends on the following:
- The size, row, column and table of the data model. If there is a complex DAX function to calculate the calculated column and table, it will be stored in the data model and increase a lot of time (you can optimize the model according to this link)
- It may also be related to hardware performance and network performance，network status between pc and datasource, and also the performance of pc which runs the power bi
In addition, if it is not the data set of the premium workspace, the refresh time is 2 hours, but the data set of the premium workspace, and the timeout is increased to five hours
There are also related documents that can optimize the data model and reduce the loading time and the possibility of similar problems:
https://docs.microsoft.com/en-us/power-bi/guidance/import-modeling-data-reduction
https://community.powerbi.com/t5/Service/Refresh-Failing-Timeout/td-p/331492
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.
