Forum Discussion
Unable to read data from the transport connection error
The solution which I have implmenented to complete all my reports was, I created "Query" instead of "Page" in Business Central and then I loaded all the queries in Power BI.
This helped me to complete all the process very smoothly.
The solution which I have implmenented to complete all my reports was, I created "Query" instead of "Page" in Business Central and then I loaded all the queries in Power BI.
This helped me to complete all the process very smoothly.
Answering just in case it helps somebody.
In my case, querying Business Central web services and then getting the error when having a few join or merge steps, buffering the tables before doing those costly steps 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.