Forum Discussion
Unable to read data from the transport connection:
Hi So aver the last two to three days I am having a varieity of issue with my Odata connection to CRM online. At first it was complaining with teh following error when trying to refresh the datas...
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.