Small and medium business | Business Central, N...

OData Data source error: time out

(0) Share

Report

Posted on by IE-30040828-0

When I try to update the data source I get this error. Translation is /It wasn't possible to read data from the transport connection: A current connection had to close the remote host computer/
Is it possible to get source data with an SQL-query through an API?

The data set is built around the query and we wan't to avoid too much work by re doing the data set

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (0)

Report

Hi, is this Query very heavy? More than 30 minutes? I recommend reducing the data or adding some filtering.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/operational-limits-online#Database

If you are on the On-Pre version, you can directly access the database and use SQL statements. But this cannot be done in SaaS.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Judy Microsoft Employee on at

Like (0)

Report

Hi sir,

I think it is possible to get source data with an SQL query through an API.

The reference Microsoft Document:

Query data using the Web API - Power Apps | Microsoft Learn

Regarding the error message it is mentioned in Microsoft Document, please check to see if it can help:

The reference Document:

Common Authoring Issues in Power Query - Power Query | Microsoft Learn

Best Regards,

Judy

Was this reply helpful? Yes No