Forum Discussion
Advocate IPowerBI Service error: OData: Unable to read data from the transport connection:
Helper VAdvocate IHi IvanS,
Case is opened with Microsoft, both Power BI and Business Central teams are currently working to resolve.
I will post the update here.
Incase anyone has any other suggestion/findings please share.
Regards,
SM
- IvanS
I have tried to reduce the number of imported rows (1 company instead of 3) and it is working without issues. Then I tried to prolong the timeout time on my original dataset but it is still failing.
So it seems that my issue is related to too much data being handled via OData feed.
- Shaishavm
IvanS when we had the issue, we were issue the cause of too many queries on a single table. Apparently Business central seems to have some cap on the number of queries. We optimized our reports to reduce the number of calls. This time, we are not sure what triggered the issue. Waiting anxiously for response from Microsoft.
You haven't tried installing 21.0 yet I presume ... our experience (as a Partner) is we have a few clients that are heavy ODATA/PowerBI users ... they all seem to complain about the same time. All have been silent for 3-4 months. But if your post is a good harbinger of what is to come, I imagine the chatter will likely pick up again soon.
- Shaishavm
Hi grantbrimhall we are on 20.5. Issue started last Friday, 7th Oct (SGT). We were already on 20.5 for more than 10 days. Not sure what was the trigger, but there was no change in the report or business central environment.
