Forum Discussion

philosopher's avatar
philosopher
Frequent Visitor
6 years ago
Solved

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....
Dataflow
Need Help
  • Icey's avatar
    Icey
    6 years ago

    Hi philosopher ,

    Engineering team have fixed the Power BI Known issue : Some Dataflow refresh fails with timeout error when enhanced compute engine is turned on for dataflow workload. Please check.

     

    Best Regards,
    Icey

     

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

jeffshieldsdev's avatar
jeffshieldsdev
Solution Sage
6 years ago

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.

  • jeffshieldsdev's avatar
    jeffshieldsdev
    Solution Sage
    6 years ago

    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.