Data gateway timout error during scheduled refresh

[webportal]

Hello,

I have an entity connected to a SQL Server database.

The gateway is installed on the server with the lastes version and all seems ok.

When I refresh the data manually in Power BI service, it takes about 1h30 minutes and the data is refreshed without errors.

However, when the data is refreshed by schedule (once a day at 1:00AM), it throws a time out error.

Why is this and how can I fix this problem?

Thank you so much for any help!

[v-lili6-msft]

hi @webportal 

Here is a same post for you refer to:

https://community.powerbi.com/t5/Service/Scheduled-refresh-timeout-but-on-demand-refresh-works/td-p/...

 and if there are multiple dateset needs scheduled refresh at 1:00AM, This could lead to gateway workload if you try to change to the time that there is no other dataset needs scheduled refresh and try it again.

Best Regards,

Lin