Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Business Central OData...
Small and medium business | Business Central, N...
Suggested answer

Business Central OData Power Query Error

(1) ShareShare
ReportReport
Posted on by Jared M 46
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
Categories:
Dynamics 365 Business Central
  • Jared M Profile Picture
    Jared M 46 on at
    Business Central OData Power Query Error
    @Judy  How can the bandwidth be increased for queries like this? There aren't that many rows and each refreshes fine (as well as the consolidated appended query) within the editor. Filtering won't help because I filter everything right after it's pulled in. 

    What happens is I have 3 separate queries in Power Query (one for each BC company) . These pull in all General Ledger lines, and then filter for a specific account range based on cells in Excel:
     
     
    In this example, I'm wanting all ledger lines from all 3 companies that hit account 6290 between January-September of 2023. This range could be expanded to have accounts 6290-6299, or any other range. These 3 queries load just fine both in the editor and in a spreadsheet. However, when I create an append query to combine all 3 results, it throws this error. The append results work fine in the editor, but for some reason, it's unable to produce the result within the Excel sheet
     
    Any ideas why this would work within the editor and not in the spreadsheet? Or any work-around suggestions? I've tried refreshing each query independently, but the append query still fails.
     
    Thanks,
     
    Jared
  • Suggested answer
    Judy Profile Picture
    Judy Microsoft Employee on at
    Business Central OData Power Query Error
    Hi Sir,
     
    The issue might be caused by Power BI generating too many concurrent calls, or by joining data from other data sources, or by refreshes happening at the same time as other refreshes.
    Please try to filter data which will improve performance and possibly avoid future issues.
    Hope it helps.
     
    Best Regards,
    Judy

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
YUN ZHU Profile Picture

YUN ZHU 313 Super User 2025 Season 1

#2
Mansi Soni Profile Picture

Mansi Soni 242

#3
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 226 Most Valuable Professional

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans