The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi
I have a dataset consisting of data sources from Power BI flow, Microsoft Business Central 365, Microsoft Ondrive, and a single webpage. Recently, Business Central made an update, that forced me to change my sources from Web Services to Advanced APIs in Power BI.
Then I started to get this new error online: OData: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action.
I found that I wasn't able to update the data on my desktop either, except if I removed a merge between a large table from an Advanced API with a smaller table from a Standard API v 2.0. It didn't matter if I made my dataset small - if I had the merge it did not work (it did work before the Business Central update).
Now I have removed the merge, and most of the time I am able to update the data on my Desktop, however online it seems random if I can make the update:
Data source error: | OData: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. |
Cluster URI: | WABI-WEST-EUROPE-E-PRIMARY-redirect.analysis.windows.net |
Activity ID: | 0e9ee190-9a21-4a03-b519-f15519792ed9 |
Request ID: | e5cda8b8-83f8-49b8-b30b-00d4336b0b62 |
Time: | 2022-05-11 23:42:18Z |
Why? And why can't I suddenly make the merge between the tables? They are the same as before, the only change is their source (and the Advanced APIs should be faster than the Web Services I was told).
Best Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Rose__123,
May I know whether you have PPU capacity or Premium capacity? If you have one of these capacities, could you please try to move the report workspace to that capacity to see whether the failures will reduce with more resources?
In addition, please try to prolong timeout as well.
Solved: Unable to read data from the transport connection ... - Microsoft Power BI Community
Best Regards,
Community Support Team _ Caiyun