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

Hi 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'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.