Forum Discussion
Merging Business Central data tables in Power Query
Hi,
I'm trying to merge two quite large tables (Item Ledger Entries and Value Entries) in Power Query. The data is imported via API's. Each time i try this, i get the following error - DataSource Error: Odata: Unable to read data from the Transport Connection. An existing connection was forcibly closed by the Remote Host.
DatasourceKind = Dynamics365BusinessCentral
Any advice as to a potential solution would be much appreciated.
thanks
Scott
2 Replies
The error you're encountering usually relates to issues with the network connection between Power Query and the Dynamics 365 Business Central API caused. Some APIs may have request size or rate limits. You can try splitting the data into smaller chunks by filtering the data from the API query before merging, or contact the API provider (Dynamics365BusinessCentral) to check if they impose any restrictions.
Hi PaisleyPrince ,
This error can be triggered for a number of reasons, usually by calling a large amount of data at once. Please check if this resolves the problem:
Download Microsoft Power BI Desktop from Official Microsoft Download Center
There's another workaround here.
Solved: Merge query crashes when loading exceeds 100 MB - Microsoft Fabric Community
If the single table loads fine, also try creating separate dataflow for these two tables as well. Then connect to these two dataflows to merge the query.
Best Regards,
Gao
Community Support TeamIf there is any 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 us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
