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
4 years ago

Hi Thanks for the replies.

 

We are on version 20.1, and we still have this issue. The issue is reduced to 2-3 times a week. Power BI support has told me that the issue is caused by large volume of transactions, caused by DimensionSetEntries table. We have optimized it and issue reduced, evern before Business Central was running version 19. 

 

I am not sure yet, what is the cause and how can it be resolved.

 

We have been having problems since Jan 2022 with no solution in sight.

 

A bit disappointed, as one of our reasons to migrate to Business Central and Power BI, was the promise of seamless integration between these apps.

 

Thanks!

SM