Forum Discussion

Shaishavm's avatar
Shaishavm
Icon for Advocate I rankAdvocate I
4 years ago

PowerBI 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 ...
Need Help
IvanS's avatar
IvanS
Icon for Helper V rankHelper V
3 years ago

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's avatar
Shaishavm
Icon for Advocate I rankAdvocate I
3 years ago

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.