Issues with scheduled automatic refresh data

Hi guys,

I really need help on this one because i can't find any documentation that could help me solve this issue.

I have 7 queries in my power bi file:

- 2 of which come from SQL Server using the import mode

- 5 of which come from different Folders (each week a new csv file is dumped in that folder)

I modified my connection time out of my 2 SQL queries to an hour. Usually they take 5-10 minutes each.

As for the folders, there is no connection timeout option. Each folder has about 30 CSV files of 1KB each.

My refreshes on average times out every 2 days. Here's a log of the error details:

4/18/2019, 10:02:10 AM        4/18/2019, 10:16:37 AM        Failed      Before the data import for Folder1 finished, its data source timed out. Double-check whether that data source can process import queries, and if it can, try again.

4/17/2019, 11:26:36 AM        4/17/2019, 11:27:36 AM        Failed      Before the data import for Folder2 finished, its data source timed out. Double-check whether that data source can process import queries, and if it can, try again.

4/17/2019, 10:02:00 AM        4/17/2019, 10:15:42 AM        Failed      Before the data import for Folder1 finished, its data source timed out. Double-check whether that data source can process import queries, and if it can, try again.

4/16/2019, 10:01:13 AM        4/16/2019, 10:41:34 AM        Completed             

4/15/2019, 3:03:26 PM          4/15/2019, 3:27:52 PM          Completed             

4/15/2019, 10:02:10 AM        4/15/2019, 10:16:44 AM        Failed      Your data gateway (personal mode) is offline or couldn't be reached.

4/14/2019, 10:01:09 AM        4/14/2019, 10:25:34 AM        Completed             

4/13/2019, 10:02:11 AM        4/13/2019, 10:59:28 AM        Completed             

4/12/2019, 4:01:14 PM          4/12/2019, 4:39:48 PM          Completed             

4/12/2019, 10:02:13 AM        4/12/2019, 10:17:15 AM        Failed      Before the data import for Folder3 finished, its data source timed out. Double-check whether that data source can process import queries, and if it can, try again.

I didint know Getting Data from Folders with small csv files could fail a refresh?

Does anyone have an explanation and ideally a solution?
note: i have a personal on-premise gateway set up.
Thank you