Hello,
We have Business Central tables connected to Power Query via OData feeds. These queries used to update just fine, but ever since adding a third company in BC, the queries throw this error:
/OData: Unable to read data from the transport connection: an existing connection was forcibly closed by the remote host/
The queries update within the Power Query editor without error, but they do occasionally take longer than normal. However, the table in the worksheet won't update and always throws this error. From previous posts on this issue, it sounds like it's too much for the query to process. I've already tried splitting the queries into smaller pieces, keeping them all together for processing, loading to separate tables first, etc. and nothing works. It seems like a Microsoft Excel insufficiency, but if there's something else we can do to get this to work, that would be greatly appreciated
Thanks,
Jared
