Forum Discussion

PBILover's avatar
PBILover
Helper V
6 years ago

Incremental data refresh for large dataset

Hi ,

trying to implement a incremental dataset refresh on the large dataset  (around 1 million row) on a premium workspace ,but at the first time that it is initial load (loading historical data) getting a timeout error.

Is there any way to handle this situation?

 

Thanks

 

 

Need Help

7 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    6 years ago

    1 million rows is not a large dataset. How many columns? What's the data source?

    • PBILover's avatar
      PBILover
      Helper V
      6 years ago

      thanks for your reply.

      Its almost 69 columns in  which some are custom columns.

      I tried to load only half million rows but still it is giving timeout error.

       

       it gives Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.

       

       

       

      • lbendlin's avatar
        lbendlin
        Super User
        6 years ago

        that is usually a transient condition (meaning you may get different results when you try again). what's the data source?