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

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?

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        RBuntingHow are you managing to download such huge dataset to your Desktop? I still dont understand why PowerBI Desktop needs to download the entire Dataflow into the desktop application. I am talking about 10s of GBs of data. Make no sense.



        v-yuta-msft 
        I tried to highlight some of the issues with Dataflow in y post here, but there is ablsutely no response ! My whole Org was couting on using Dataflow for enterprise level ETL.
        https://community.powerbi.com/t5/Service/Dataflow-Dataset-NEED-more-Clarity/td-p/735330