This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have three tables created by connecting to a Dynamics Business Central database via the OData feed connector. These tables can load into Excel individually but when merged in Power Query, the merged table does not load throwing back the following error message.
DataSource.Error: OData: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.
Details:
DataSourceKind=OData
DataSourcePath=https://elvadms.*******.com:7048/ELVAAPP1/ODataV4/Company('C1-***** Corporation Limited')/Customers
How to resolve this?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Has this been solved ? I am having same problem
There was no resolution. I ended up having to download individual files to create the final table I needed.