Forum Discussion
Shaishavm
Advocate I
Advocate IPowerBI 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 ...
Has there been any progress on this issue? Just started happening to me last week.
My data source is Business Central of course.
Answering just in case it helps somebody with the same problems querying Business Central.
Buffering the tables before doing those costly steps (Merges, Joins) helped being able to refresh the report in the desktop. The report wasn't failing in the Power BI Service.
2025 edit: after still getting the error, although less frequently, I might add that as somebody has mentioned before, setting the same datatypes for the columns involved in a join helps reducing the occurrence of the problem.