ODATA data load issues

[rnimmala]

Hi Team,

I am getting below error while trying to connect to SAP HANA data through ODATA service URL.

The server only lets us extract a max of 5000 records. When we try to extract more or all the records we get the error below.

DataSource.Error: Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed:
OData Version: 3 and 4, Error: The remote server returned an error: (500) Internal Server Error. (500 Connection Timed Out

2024-04-26 10:50:25)
OData Version: 4, Error: The remote server returned an error: (406) Not Acceptable. (Not Acceptable)
OData Version: 3, Error: The remote server returned an error: (500) Internal Server Error. (500 Connection Timed Out

2024-04-26 10:51:35)

In the Power Query, we even tried to increase the timeout duration, but the issue still persists.

Can someone please suggest how to fix the issue?

Thanks

[v-zhengdxu-msft · Accepted solution]

Hi @rnimmala 

You mentioned attempting to increase the timeout duration without success. It's crucial to ensure that the timeout settings are correctly applied. For Power Query, the timeout settings might need to be adjusted in multiple places, including the data source settings and gateway configurations if applicable.

For more on setting timeout values, please refer:

Solved: Odata #timeout parameter not working? - Microsoft Fabric Community

excel - How to set a max run time / timeout for Power Query? - Stack Overflow

How to increase the timeout of Odata, I am getting... - SAP Community

To work around the 5000 record limit, consider implementing pagination or server-side filtering in your OData query. This approach allows you to retrieve data in chunks or only the specific records you need, thus avoiding the limit.

Here for your reference:

URI Conventions (OData Version 2.0) · OData - the Best Way to REST

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.