cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
philosopher Frequent Visitor
Frequent Visitor

DataFlow timeouts

Hi all, I hope someone can shed some light here.

It's been a week since most of our Dataflows fail to refresh with timeout, after 2 hours.

It's not a database timeout issue, as someone would guess.

I have monitored database traffic, queries run as expected, they end normally, but the calling DataFlow continues to run until it fails with timeout.

We're seriously considering switching off DataFlows, although it seemed like a great feature.

We have our production down for a week now, I have to do something else rather than looking at them fail every day.

Thanks

 

 

13 REPLIES 13
Super User
Super User

Re: DataFlow timeouts

@philosopher Are you running the dataflows on a workspace that is in capacity? If so, what are the capacity metrics showing in the performance report - (Power BI Premium Capcacity Metrics App)? You could be hitting memory issues if your capacity is not large enough.


Near SE WI? Join our PUG Milwaukee Brew City PUG
philosopher Frequent Visitor
Frequent Visitor

Re: DataFlow timeouts

Nope, no capacity, no premium

Icey Super Contributor
Super Contributor

Re: DataFlow timeouts

Hi @philosopher ,

Please check if your gateway is on. And if possible, try to keep your gateway up to date. 

If the issue is still there, please give me more details, such as:

1. What's your data source?

2. What's the error message?

 

And I find one workaround, maybe you can refer to.

https://community.powerbi.com/t5/Service/Dataflow-Timeout/td-p/614925

dataflow.PNG

 

Best Regards,
Icey

 

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

Highlighted
jochungJE Frequent Visitor
Frequent Visitor

Re: DataFlow timeouts

I have the exact same problem. My Dataflow for the "linked entities" been failing since Saturday, the Dataflow these linked entities reference from do not have any issue with the refresh.

 

The error I have been getting related to "Param1 = Execution Timeout Expired".  I have submit a support ticket hoping to get some help.

 

philosopher Frequent Visitor
Frequent Visitor

Re: DataFlow timeouts

Hey @jochungJE 

Please keep us posted with the progress on your support ticket, I'm getting a bit desperate here.

"Execution Timeout Expired" is our error too.

It randomly appears on various DataFlows.

I have monitored the db usage and running queries at the time of the errors, there's nothing wrong there, queries begin and end in time. Yet, the data flows continue to be 'refresh in progress' until they fail with timeout. 

Re: DataFlow timeouts

I've been getting this error trying to refresh dataflows since Saturday:

 

Error: An internal error occurred... RootActivityId = xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx.Param1 = Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Request ID: xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx.

 

I've been refactoring my dataflows all weekend, trying to resolve the error...I didn't figure it was on the Microsoft side.

 

I'll submit a ticket too, please let us know if you hear anything.

 

I'm using the Enhanced Compute Engine, on Power BI Premium.  Data source is Azure SQL DB, but is happening for on-prem Teradata also.

Re: DataFlow timeouts

Sorry to hijack your thread.

Microsoft support called me back.  He confirmed seeing all my dataflow refresh errors over the weekend in logs.  He doesn't see anything misconfigured in my queries.  He's going to get an Azure SQL DB set up and do more testing.

Icey Super Contributor
Super Contributor

Re: DataFlow timeouts

Hi @philosopher ,

This is a New Known Issue added for Power BI - Some Dataflow refresh fails with timeout error when enhanced compute engine is turned on for dataflow workload.

I suggest you to Disable SQL compute engine and retry.

If the issue is still there, please be patient and the engineers will fix it as soon as possible. I will notify you of any updates.

 

Best Regards,
Icey

 

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

jochungJE Frequent Visitor
Frequent Visitor

Re: DataFlow timeouts

Thanks @Icey .

 

I have disable the enhanced compute engine and try to refresh the dataflow again. It seems to be working now.

 

At the same time, I received email on my support ticket, pointing to the same solution as well.

 

Regards,

joC

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 204 members 2,323 guests
Please welcome our newest community members: