Forum Discussion
"Error: DataSource.Error: Microsoft SQL: Execution Timeout Expired" When Refreshing Data Flow
I found this about Azure databases
"As you noticed, connecting to Azure SQL DB is a little different from connecting to a Microsoft SQL Server. Generally for Azure, you connect to individual databases, not an entire server - so there's really no concept of configuring server timeout settings"
I think this means that you cant do anything about the timeout on the SQL DB side?
Hi Anonymous ,
In the Data Source Settings for the SQL Server database you can increase the timeout. (You can modify it in the Data Source Settings itself or if this is just one place you are using it, you can modify it in the M code in the Source line.)
I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!
I found this about Azure databases
"As you noticed, connecting to Azure SQL DB is a little different from connecting to a Microsoft SQL Server. Generally for Azure, you connect to individual databases, not an entire server - so there's really no concept of configuring server timeout settings"
I think this means that you cant do anything about the timeout on the SQL DB side?