Query timeout

[CarlsBerg999]

Hi,

I have an Odata query that is made from the source below. I sometimes get an error that the "An existing connection was forcibly closed by the remote host". I would like to extend the query before timeout comes. 

let
Source = OData.Feed("https://my999999.sapbydesign.com/sap/byd/odata/ana_businessanalytics_analytics.svc/OFIWNMEIQueryResu...", null, [Implementation="2.0"]),

Apparently PowerQuery does have [Timeout=#duration(0,0,15,0)] but im not quite sure how to use this in a PQ. How do i extend my Odata query above to put the timeout after 15min?

Thanks!

[v-jingzhang]

Hi @CarlsBerg999 

You can try this:

Source=OData.Feed("https://my999999.sapbydesign.com/sap/byd/odata/ana_businessanalytics_analytics.svc/OFIWNMEIQueryResu...", null, [Implementation="2.0", Timeout=#duration(0,0,15,0)]),

Reference: OData.Feed - PowerQuery M | Microsoft Docs

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

[lbendlin]

This article may help:

Configuring Power Query OData Feeds – Prologika