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.
