Forum Discussion

H_insight's avatar
H_insight
Helper V
3 years ago

DataSource.Error: Unable to read data from the transport connection:

Hi All,

 

I am having an issue using incremental refresh with dataflows, which I am not sure how to resolve.

 

Current Setup: The dataflow is connected vie "Web" connector and consumes data from an API (so no gateway is needed). the dataflow refreshes fine without setting up the incremental refresh. However, the moment I try to configure the Incremental refresh I get this message:

"Error: Data Source Error : DataSource.Error: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host."

 

I have a DateTime column to use, and I am only looking to store the past 2 years with a daily refresh.

 

Not sure what I am missing? Any idea/help please?

 

Thanks

7 Replies

  • This needs some more details. Does your API support time range filters?  Did you apply them in the URL?  How?

    • H_insight's avatar
      H_insight
      Helper V

      My source is JIRA and I believe it supports time range filters. The issue is that the dataflow runs with a FULL refresh in less than 2 mins with no issue. Only when I try to configure the Incremental Refresh, it keeps failing and gives the error message.

      Configuration: Store rows for the last 2 years and refresh for 1 day.

       

      • lbendlin's avatar
        lbendlin
        Super User
        The issue is that the dataflow runs with a FULL refresh in less than 2 mins with no issue.

         

        I fail to see the issue here 🙂  What problem are you trying to solve?