Power BI refresh

[Serenge]

I am encountering an issue with a Power BI dashboard that retrieves data from Dynamics 365 Business Central (on-premises) via an OData connection. After publishing the dashboard and setting up a daily refresh, the refresh process consistently fails with 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. 

[rajendraongole1]

Hi @Serenge -you're encountering is often related to network issues, security settings, or limitations on the server side. Check for any intermittent network connectivity issues that could be causing the connection to drop. if the server hosting Dynamics 365 Business Central has sufficient resources (CPU, RAM, etc.) to handle the data refresh requests.server logs to identify any performance bottlenecks or errors that coincide with the data refresh attempts.

Reference link

OData.Feed And The Dynamic Data Sources Error In Power BI (crossjoin.co.uk)

Power Query OData Feed connector - Power Query | Microsoft Learn

Hope it helps

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!