Refresh errors

[Anonymous]

What is this error about? This connection is with SQL Server Management Studio.

OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding..

OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

Please set the timeout option and check again.

[Anonymous]

Hello-

  It likely means that your SQL Server is down and/or being re-built.

Jared

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

Please set the timeout option and check again.

[Anonymous]

Can I just set it to no timeout?

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

The max value is 2 hours. To set set the timeout value freely, there is an idea about that you can vote it up to make this feature coming sooner.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/32582299-improve-the-feature-to-be-set-the-timeout-value-fr

[MitieFred]

@v-frfei-msft @Anonymous 

we are experiencig the same problem, where is this setting to be found please ?