Forum Discussion
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
- lbendlinSuper User
This needs some more details. Does your API support time range filters? Did you apply them in the URL? How?
- H_insightHelper 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.- lbendlinSuper 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?