ODATA data load issues

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.