data source timed out , refreshing process failed

[hisham2021]

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

[Anonymous · Accepted solution]

Hi  @hisham2021 ,

If you are using import mode, the data loading time depends on the following:

1. 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)
2. 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.

[ibarrau]

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,

[hisham2021]

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.