web
You’re offline. This is a read only version of the page.
close
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... / An error occurred whil...
Small and medium business | Business Central, N...
Suggested Answer

An error occurred while processing the data in the semantic model.

(4) ShareShare
ReportReport
Posted on by SA-17061734-0 8
Hi
I am facing this error daily when connecting Business Central to Power BI as a data source! It is happening on the Web Power BI services, which users can access.
 
<ccon>OData: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.</ccon>. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. Table: Date_Gross.
 
I talked to Power BI support, but there wasn't any issue with the Power BI server, and their idea was that it was a Business Central connection issue.
Is there any solution to fix it? It causes users to lose the refreshed data.
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Jonas "Jones" Melgaard Profile Picture
    Jonas "Jones" Melgaard 4,926 Most Valuable Professional on at
    Moved from General to SMB that works with Business Central

    I don't recall what the issue might be, but people here might be able to answer your question. (-:
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 95,331 Super User 2025 Season 2 on at
    Hi, Hopefully the following discussion can give you some hints.
     
    Thanks.
    ZHU
  • Suggested answer
    Sohail Ahmed Profile Picture
    Sohail Ahmed 11,136 Super User 2025 Season 2 on at
    adding more details
     
     
    ✅ Mark this answer as verified if it helps you.
  • Gerardo Rentería García Profile Picture
    Gerardo Rentería Ga... 25,157 Most Valuable Professional on at

    Hi, good day
    I hope this can help you, and give you some hints.

    Solved: oData connection to Business Central (on prem) - f... - Microsoft Fabric Community

    Best Regards
    Gerardo

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,143

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,694 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,067 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans