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

v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

Anonymous,

 

Please refer to below:

 

There are a few known limitations to using Enterprise Gateways and dataflows:

  • Each dataflow may use only one gateway. As such, all queries should be configured using the same gateway.
  • Changing the gateway impact the entire dataflow.
  • If several gateways are needed, the best practice is to build several dataflows (one for each gateway) and use the compute or entity reference capabilities to unify the data.
  • Dataflows are only supported using enterprise gateways. Personal gateways will not be available for selection in the drop down lists and settings screens.

Community Support Team _ Jimmy Tao

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

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