topic Scheduled refresh using odata time out error in Developer

Scheduled refresh using odata time out error

prioritybi — Fri, 17 Jun 2022 10:01:15 GMT

Hi,

It takes us a long time to redresh using odata connection, and using the scheduled refresh shows error: time out

Tried to resolve it by using incremental refresh and didnt work.

Is there a solution how to increase or cancelled the time limit of the refresh?

Thanks

Re: Scheduled refresh using odata time out error

Hariharan_R — Fri, 17 Jun 2022 14:27:21 GMT

Try change the timeout as like below mentioned.

Ref - https://forums.invantive.com/t/avoid-timeout-error-on-power-bi-odata-download/1857#how-do-i-change-the-odata-query-timeout-4

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

My Blog :: YouTube Channel :: My Linkedin

Re: Scheduled refresh using odata time out error

Anonymous — Thu, 23 Jun 2022 06:18:12 GMT

Hi @prioritybi,

How long did the timeout issue appear? If they do not exceed the maximum timeout settings, you can change the timeout property in your query to increase the processing times.

Troubleshooting refresh scenarios - Power BI | Microsoft Docs

Scheduled refresh timeout
Scheduled refresh for imported datasets timeout after two hours. This timeout is increased to five hours for datasets in Premium workspaces. If you encounter this limit, consider reducing the size or complexity of your dataset, or consider refactoring the large dataset into multiple smaller datasets.

If they are already over the limit, I think you need to upgrade your license to increase the maximum timeout of refresh processing or try to add query filters to reduce the loaded data amounts.

Regards,

Xiaoxin Sheng