Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Dataflow Timeout

Hi all,   Anyone know a way to stop the dataflow timing out.   Datasource is on-prem SQL database, using a native query. Result set is in the millions   Thanks   Mike    
Need Help
  • Galia's avatar
    Galia
    7 years ago

    Hi Mike,

     

    Please send to our support email the screenshot with the failure you got, so we can investigate further.

     

    Thanks,

    Galia

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi,

 

We are using an enterprise gateway and just have one gateway for all dataflows.

 

Regards

 

Mike

Galia's avatar
Galia
Microsoft Employee
7 years ago

Hi Mike,

 

Can you please share the refresh log (by downloading the CSV file from the refresh history)?

Please mail it to dataflow support DL: [email protected]

 

Thanks,

Galia

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Galia

     

    I don't get to the refresh stage as the dataflow times out when I am previewing the data when building the dataflow.

     

    I am unable to save the dataflow.

     

    Regards

     

    Mike

    • Galia's avatar
      Galia
      Microsoft Employee
      7 years ago

      Hi Mike,

       

      Please send to our support email the screenshot with the failure you got, so we can investigate further.

       

      Thanks,

      Galia

      • RBunting's avatar
        RBunting
        Advocate III
        7 years ago

        I am also having a problem like this.  Do we know any more about Time Out control?

         

        I am trying to retrieve a portion of a large table - about 10 of 88MM rows.  If I load that data into its own SQL table, the Dataflows priview loads instantly.  But if I try to load from the correct table, DataFlows works at it for about 10 minutes and quits.  

         

        I wouldn't expect the query to complete in SSMS in that time.  How can we get Dataflows preview to be a little more patient?