Issues with scheduled automatic refresh data

[RogerSteinberg]

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

[v-juanli-msft]

Hi @RogerSteinberg 

Prior IcM had this same error, it is said lastest version seems to fix this.

please download the lastest version of gateway and Power BI Deskop (if you use Power BI Desktop to connect and publish).

https://powerbi.microsoft.com/en-us/gateway/ (suggest you install the on-premise gateway instead of personal mode)

https://docs.microsoft.com/en-us/power-bi/desktop-latest-update

If error still occur, you could create a support ticket which is free for pro users.

https://powerbi.microsoft.com/en-us/support/

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[RogerSteinberg]

Two things:
- what is IcM?

- why download the on-premise instead of personal mode?

Thank you