Forum Discussion

Shaishavm's avatar
Shaishavm
Advocate I
4 years ago

PowerBI Service error: OData: Unable to read data from the transport connection:

Hi,    Our Power BI reports fetch data from Dynamics 365 Business Central using the native connector. However, since the Business Central version was updated to 20.0 (Release Wave 1 2022), refresh ...
Need Help
n2k's avatar
n2k
Frequent Visitor
1 year ago

Hello,

 

I experienced the same issue. When loading the tables it always stopped in the same MB loaded and after time, it have the following error: OLE DB or ODBC error: [Data.Source.Error] OData: Unable to read data from the transport conenection: An existing connection was focibly closed by the remote host. 

What i did to solve my issue was:

 

  1. Go to File > Options and Settings > Options.
  2. Under Global > Security, uncheck the option "Require user approval for new native database queries".
  3. Click OK.

Once refreshed, I activated again.

 

Hope this helps.