Forum Discussion

Gadik's avatar
Gadik
Frequent Visitor
3 years ago

Incremental refresh - 10 min timeout

Hello,   We are having Premium capacity workspace, with a model defined with incremental refresh. The data source is Oracle. Frequently we see that the refresh is failed, 10 min after it was start...
Need Help
v-xiaosun-msft's avatar
v-xiaosun-msft
Community Support
3 years ago

Hi Gadik ,

 

The default timeout for a SQL Server database is set to 10 minutes.

Try to turn to Transform Data -> Data source settings. And then set the timeout minutes.

Or you can try to edit it in Power Query.

Sql.Database("DatabaseServer", "DatabaseName", [CommandTimeout=#duration(0, 1, 30, 0), CreateNavigationProperties=false])

 

Please follow the following document.

Ensuring your Power BI Incremental Refresh does not Timeout when using a SQL Server Source - FourMoo | Power BI | Data Analytics

Troubleshoot incremental refresh and real-time data in Power BI - Power BI | Microsoft Learn

 

Best Regards,
Community Support Team _ xiaosun

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

Gadik's avatar
Gadik
Frequent Visitor
3 years ago

Thank you for your reply, but it is an Oracle database. And some other queries are running for longer periods and not failing.