Scheduled refresh using odata time out error

[prioritybi]

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

[Anonymous · Accepted solution]

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

[Hariharan_R]

Hi

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-t...

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