Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
PBITK
New Member

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

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:01Schemalagt00:07:36Slutfördsuccess
2020-06-10 11:01:17Schemalagt00:11:06Slutfördsuccess
2020-06-10 10:30:01Schemalagt00:02:00Misslyckadesfail
2020-06-10 10:01:02Schemalagt00:10:36Slutfördsuccess
2020-06-10 09:30:01Schemalagt00:09:06Slutfördsuccess
2020-06-10 09:01:09Schemalagt00:05:01Misslyckadesfail
2020-06-09 19:00:01Schemalagt00:02:31Misslyckadesfail
2020-06-09 15:10:28På begäran00:09:35Slutfördsuccess
2020-06-09 13:35:12På begäran00:02:00Misslyckadesfail
2020-06-09 11:30:44På begäran00:10:34Slutfördsuccess
2020-06-09 11:24:01På begäran00:01:31Misslyckadesfail
2020-06-09 09:44:09På begäran00:02:00Misslyckadesfail
2020-06-09 08:42:27På begäran00:09:04Slutfördsuccess
2020-06-09 08:27:42På begäran00:02:00Misslyckadesfail
2020-06-09 08:00:52På begäran00:03:31Misslyckadesfail
2020-06-08 19:00:00Schemalagt00:02:01Misslyckadesfail
2020-06-07 19:00:02Schemalagt00:05:06Misslyckadesfail
2020-06-06 19:00:02Schemalagt00:02:34Misslyckadesfail
2020-06-05 19:00:02Schemalagt00:07:34Slutfördsuccess
2020-06-04 19:00:01Schemalagt00:09:06Slutfördsuccess

 

5 REPLIES 5
rsreddy
Regular Visitor

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
Advocate I
Advocate I

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
Community Support
Community Support

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
Community Support
Community Support

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:

 

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
Super User
Super User

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?

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.