Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
RogerSteinberg
Post Patron
Post Patron

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

2 REPLIES 2
v-juanli-msft
Community Support
Community Support

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.

Two things:
- what is IcM?

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

 

Thank you

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors