Timeout Error in Power BI

[Anonymous]

Hi,

Sometimes one of the report in my workspace in power bi service is showing the below error after few minutes of refresh.

Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time. This failure occurred while attempting to connect to the routing destination. The duration spent while attempting to connect to the original server was - [Pre-Login] initialization=1; handshake=9; [Login] initialization=0; authentication=0; [Post-Login] complete=0; The duration spent while attempting to connect to this server was - [Pre-Login] initialization=34005; handshake=0;

Most of the times the report is refreshing. 

Please help me out to fix this isuue.

Thanks.

[v-qiuyu-msft]

Hi @Anonymous, 

Please increase connection timeout. This can be done by editing the report in PBI Desktop and updating the query to use connection timeout and then republish their report to PBI Service. They may have to try out different duration to check the connection timeout. See details here - https://docs.microsoft.com/en-us/powerquery-m/sql-database

Example:
Source = Sql.Database("Servername", "tablename", [option1, option2, ConnectionTimeout=#duration(0, 0, 20, 0)])
or
Source = Sql.Databases("Servername", [option1, option2, ConnectionTimeout=#duration(0, 0, 20, 0)])

Best Regards,
Qiuyun Yu