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