Loading error when merging tables whose data source connector is OData feeds.

Question

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?

Answer 1

https://elvadms.simbacorp.com:7048/ELVAAPP1/ODataV4/Company('C1-Simba%20Corporation%20Limited')/Customers

this URL which need user name and pass word to authorize access.

Answer 2

Has this been solved ? I am having same problem

Answer 3

Your file link only works for organization account.

You may upload file in private message.

Private Messages - Microsoft Community

Answer 4

These are the error messages when I try to load or refresh the merge query.

I want to merge the three tables accessed through this link OData Customers.xlsx to create a unique list of customers with the columns "C1", "C3" and "C4" found in each respective table. While the merge procedure works just fine, the load into excel brings these errors out.

Note: This error doesnt arise if these primary tables are made static by dowloading and storing them.

Answer 5

Could you share a screenshot of your issue? Is it possible to share a test file to reproduce your issue?

For sharing file, you may upload it to OneDrive or any other cloud drive and then post the link here.