Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Dataflow - Status Failed - Timeout Error

Hi all,   I'm hoping anyone have a good idea on the issue I'm currently facing with my Dataflow   My dataflow is currently loading data from 2 views (let's call it Query 1 and Query 2) where the ...
Dataflow
  • v-xuding-msft's avatar
    v-xuding-msft
    6 years ago

    Hi Anonymous ,

     

    Please add the parameter of timeout into PQ query to have a try.

    [Query="< query is here >", CommandTimeout=#duration(0, 1, 0, 0)]

     

    A user encounter the issue while editing dataflow without doing any changes.  And his problem hasn't fixed for now. I don't know if your situation is same as his.  Please try the code above firstly. If it still don't work,  please create a support ticket to get the dedicated support.

    How to create a support ticket in Power BI  

     

v-xuding-msft's avatar
v-xuding-msft
Community Support
6 years ago

Hi Anonymous ,

 

Could you tell me if your problem has been solved? If it is, kindly share your solutions. More people who encounter the same issue will benefit from here. 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi XD,

 

Thank. It seems to solve my issue but at the same time, I've also scaled up the source (Azure SQL) and broken down my dataflow into multiple dataflows and hold less entities

 

I'm still monitoring but I'm convinced the setting did help

 

Cheers