Forum Discussion
Advocate IPowerBI Service error: OData: Unable to read data from the transport connection:
Community SupportHi Shaishavm,
Thanks for your reply! I got it. May I know whether you receive any update from Business Central support team?
Best Regards,
Community Support Team _ Caiyun
Hi: I work for a Microsoft Partner. This is a pervasive problem. This mysterious "Unable to read data from the transport connection. The connection was forcibly closed by the remote host." It comes and it goes. As the author has indicated, his ODATA connections have worked great for 2 years. Then all the sudden they don't. We had other clients on BC that were great until v20. And then they get this dreaded error. (not all of them, but many). One client's errors went away after upgrading to v20.1. But like this author, we have another client who is still problematic after v20.1.
I've been chasing this error for 12-18 months. It comes and it goes. Seems like the past few weeks we are getting an extraordinary amount of these errors. I don't think it's necessarily a BC v20 issue. But I imagine in a week or so, this error will go away for the most part. Then stay quiet for a couple months. Then lots of customer will complain about it again.
Nobody at BC or PowerBI/Query will take ownership of this. they just point the finger at each other. I'm trying to get Fiddler logs to help ascertain the problem. But by the time I get them setup, I can't recreate the error again. I'm going to try again now.
- v-cazheng-msft
Thanks for the info! I got it. Please observe the work of the v20.1 Connector in the future days. If you find this issue happen again, then please reach to the support with your logs for further investigation. Thanks in advance!
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let me know. Thanks a lot!
Best Regards,
Community Support Team _ Caiyun
Thanks for the update. I have a client that experiences the same. Once in a while the scheduled update goes through - but mostly it fails. It started some weeks ago, but I am not aware of wether there has been any upgrade to their BC.
The current version is:
Business Central 20.1 (platform 20.0.39668.42066 + program 20.1.39764.39901)
Does these versions match any of the BCs you are having issues with. I am no BC expert - so maybe a stupid question, but here goes: Can you choose to upgrade either platform or program or does it have to be both. Is it an easy task for the BC partner og should we expect it to take days, weeks or months?
This also happens in D365FO, so it's not restricted to BC. WOrks for a few days and then "bam" get the same error message. Shambolic software that drives people away from Microsoft Products because of their lack of ownership of problems!!
