Unable to read data from the transport connection: An existing connection was forcibly closed by the

[PBITK]

I have a data flow that retrieves information from a sharepoint folder. When I schedule updates to this data feed, about 60% of the attempts fail. When things go wrong, I get the error message: "Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host" The update is not very large as it takes approx. 10 min. I should add that the folder I retrieve information from is on shared resource in my one drive.

Körtid Typ Varaktighet Status  

2020-06-10 11:30:01	Schemalagt	00:07:36	Slutförd	success
2020-06-10 11:01:17	Schemalagt	00:11:06	Slutförd	success
2020-06-10 10:30:01	Schemalagt	00:02:00	Misslyckades	fail
2020-06-10 10:01:02	Schemalagt	00:10:36	Slutförd	success
2020-06-10 09:30:01	Schemalagt	00:09:06	Slutförd	success
2020-06-10 09:01:09	Schemalagt	00:05:01	Misslyckades	fail
2020-06-09 19:00:01	Schemalagt	00:02:31	Misslyckades	fail
2020-06-09 15:10:28	På begäran	00:09:35	Slutförd	success
2020-06-09 13:35:12	På begäran	00:02:00	Misslyckades	fail
2020-06-09 11:30:44	På begäran	00:10:34	Slutförd	success
2020-06-09 11:24:01	På begäran	00:01:31	Misslyckades	fail
2020-06-09 09:44:09	På begäran	00:02:00	Misslyckades	fail
2020-06-09 08:42:27	På begäran	00:09:04	Slutförd	success
2020-06-09 08:27:42	På begäran	00:02:00	Misslyckades	fail
2020-06-09 08:00:52	På begäran	00:03:31	Misslyckades	fail
2020-06-08 19:00:00	Schemalagt	00:02:01	Misslyckades	fail
2020-06-07 19:00:02	Schemalagt	00:05:06	Misslyckades	fail
2020-06-06 19:00:02	Schemalagt	00:02:34	Misslyckades	fail
2020-06-05 19:00:02	Schemalagt	00:07:34	Slutförd	success
2020-06-04 19:00:01	Schemalagt	00:09:06	Slutförd	success

[rsreddy]

I am also  facing same issue, please refer below error message. The refresh is normal sucessfull in desktop App.

Failure details: OData: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.

Please advise.

[monty]

Same problem here with most larger OData downloads. Error occurs one minute after the OData download completes as visible from the originating server. See also https://forums.invantive.com/t/in-power-bi-robaws-connector-odata-unable-to-read-data-from-the-trans... (Dutch). Seems that problem occurs for individual downloads just above 10 MB (compressed) size typically. The data model size does not seem to have an impact. Occurs with small and very large (16.000 columns) data models.

[v-yingjl]

Hi @PBITK ,

If you've fixed the issue on your own please kindly share your solution. If the above posts help, please kindly mark it as a solution to help others find it more quickly. Thanks!

Best Regards,
Yingjie Li

[v-yingjl]

Hi @PBITK ,

1. Too large data model may be a reason for your scenario, maybe you can try to cut down you data size and try again.
2. You can try to update your .NET framework to the version which supports TLS 1.2 and TLS 1.2 should then be enabled by default. Refer:
   • How to enable TLS 1.2 
   • Install the .NET Framework 

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

That was a longstanding issue that was acknowledged on https://powerbi.microsoft.com/en-us/support/ but it has now dropped from the page so is supposedly fixed?