Forum Discussion

TomaszTub's avatar
TomaszTub
Regular Visitor
2 years ago

Business Central SaaS Odata connection

Hi,

 

I have a few reports which using OData connection from business central. Report was made for Business Central on-premise. After migration to online version I started to receive an error "Connection was closed by remote host". I thought it is because some response time are different and I cut some data but I have no effect (from one year to one month). Strange thing is sometimes this report can be refreshed. I try 10 times and once I can refresh. 

I have two separate databases, Excel power query and Power BI and the same problem. Some reports with 1 GB some with 100 MB problem is the same.

Error is form function  Table.ExpandTableColumn. Any suggestion?

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi TomaszTub ,

    The error "Connection was closed by remote host" can occur when dealing with importing large amounts of data from online sources. This error can also occur when using the OData connector in Power BI desktop, and it might be due to throttling from the data source end.One possible solution is to reduce the amount of data being imported. If you're already tried reducing the data and the problem persists, it might be due to the data source not being able to provide the data within the default timeout of the OData connector, which is 10 minutes.You can try increasing the timeout value in your M code. For example, you can set the timeout value to 30 minutes like this: 

    OData.Feed("https://services.odata.org/V3/Northwind/Northwind.svc", null, [Timeout=#duration(0,0,30,0)])

    OData.Feed - PowerQuery M | Microsoft Learn


    If the problem still persists after increasing the timeout, it might be necessary to work with the owner of the data source to ensure it doesn't take too long to provide the data or to further reduce the amount of data being imported.
    If you have enabled query caching in your dataset, you might want to turn it off if you always want to see the latest data.


    Please try these suggestions and see if they help resolve the issue.

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group