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

rdnguyen's avatar
rdnguyen
Helper V
3 years ago

Not sure if anyone is still concern about this; but you can split the whole datatable in SQL into multiple segments; then the oldest data is loaded overnight one by one. Then at the transforming phase, you can merge them all together using resource of Power BI service. That should work to bring in huge amount of data like you said.