cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dyabes
Helper I
Helper I

Dataflow suddenly couldn't be refreshed

I setup my dataflow refresh and was doing great for a couple of days. These are multiple Google Spreadsheets as sources. Then suddenly all refresh is failing with the following error message -- "Your dataflow couldn't be refreshed because there was a problem with one or more entities, or because dataflow capabilities were unavailable."

 

Refresh history log shows there is one entity that is exceeding 2 hours of refresh limit.

2019-10-30_9-47-18.png

 

Checked the entity that was throwing error in "Edit queries" mode and everything is loading OK. 

 

Another interesting event -- I cancelled the refresh to disable the schedule refresh temporarily. The refresh still keeps on triggering. In one cancel, a refresh was surprisingly completed.

2019-10-30_9-44-10.png

 

I'm thinking of rebuilding the entity that was giving the error but before that would like to get more ideas and nailing down the root cause so as not to happen again.

 

Cheers,

David

1 ACCEPTED SOLUTION
venal
Memorable Member
Memorable Member

@dyabes 

Hoping that there was some intermittent issue with Google or Service.

Please try to re-pro the issue once again and if the issue is persists, please raise a support ticket to investigate.

Note:- always maintain the latest versions (Power BI Desktop and On-premises Data Gateway).

 

If this post helps, then please consider Accept it as the solution to help the other members find it more

If this post was helpful may I ask you to mark it as solution and give it some kudos?

View solution in original post

6 REPLIES 6
dyabes
Helper I
Helper I

The issue returned this morning with the exact same error but on a different entity. 😞

 

Sad that without proper solution, we can't build reliable products between Dataflow and GoogleSpreadsheet.

dyabes
Helper I
Helper I

The individual entities are refreshing just fine. Tried manually refreshing the dataflow but keeps on going way past it's expected refresh time so it appears something is still broken. 

 

Issuing a support ticket and will update this thread for any solution.

 

Cheers,

D

I seem to have similar issue, with some simple entities in my dataflows exceeding the 2hour limit, started last few days.  Strangly, when I duplicate the same entity to a different name and disable-load the original entity, the refresh worked (with the new duplicate).  But when I return the original entity back on, fails again.  I will also create ticket with MS.

 

Error msg: Refreshing an entity exceeded the 2 hour refresh limit.

evlogihr
Regular Visitor

We have been using Dataflows for months now. And currently we have the same issue since Sunday, 27 Oct. Dataflows that used to refresh in 10-15 mins started to Fail with Error: Refreshing an entity exceeded the 2 hour refresh limit.

evlogihr_0-1572441220712.png
I did rebuild and move the Dataflow but that did not help.

Cheers,

Evlogi

I have exactly the same behavior since this morning. A Data Flow which was refreshing fine for months, with a average duration of around 5 minutes, suddenly fails with 2h timeout. I'm curious that the failing entity is one of the simplest inside this data flow. Not much data, not much complexity compared to the other entities.

Other data flows are running fine, and even if i copy the failing data flow, remove everything but the failing entity and refresh the data flow, everything works fine and it takes only about 1 minute.

Data Source is SQL Server through on-premises data gateway.

venal
Memorable Member
Memorable Member

@dyabes 

Hoping that there was some intermittent issue with Google or Service.

Please try to re-pro the issue once again and if the issue is persists, please raise a support ticket to investigate.

Note:- always maintain the latest versions (Power BI Desktop and On-premises Data Gateway).

 

If this post helps, then please consider Accept it as the solution to help the other members find it more

If this post was helpful may I ask you to mark it as solution and give it some kudos?

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!