cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted

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
Community Support Team
Community Support Team

Re: Issues with scheduled automatic refresh data

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.

Re: Issues with scheduled automatic refresh data

Two things:
- what is IcM?

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

 

Thank you

Helpful resources

Announcements
Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors