Forum Discussion
DataSource.Error: Unable to read data from the transport connection:
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?
What I meant here is that the dataflow runs with no issues IF I run a full refresh. But once the full refresh is complete and I try to configure the incremental refresh, it keeps failing.
In summary, if a dataflow runs with a full refresh in less than 2 mins, what can cause the incremental refresh to fail and give the referenced error?
PS: The full refresh step is to troubleshoot if the dataflow has any errors or timeout issues which may affect the Incremental refresh. That's why I mentioned
The issue is that the dataflow runs with a FULL refresh in less than 2 mins with no issue.
I hope that helps.
- lbendlin3 years agoSuper User
If your full refresh finishes within two minutes then you don't need to setup the incremental refresh. Performance has to be two orders of magnitude worse to consider incremental refresh.
- H_insight3 years agoHelper V
I appreciate your view but avoiding the incremental refresh issue won't solve my problem 🙂
So far from testing, this is not due to DB size or timeout. My goal is to understand the root cause and what went wrong for this to happen. Could it be the JIRA server refusing the connection? But if so, why would it accept the full refresh?
- lbendlin3 years agoSuper User
You would have to provide more details on your incremental refresh setup. At a minumum please show a sanitized version of your Power Query code.