Forum Discussion
Power BI Gateway - Timeout Error When Connecting to SQL Data Source
If changing the timeouts from your query hasn't changed anything and still send the timeout in the same amount of seconds, then go to the DB team. There might be something on the SQL Server side for timeout the connections or queries.
Regards
Hi. By default a connection dataflow is very short period, it's like 10 seconds before timeout. You can increase that value in the Power Query code. If you check the docs for sql databases:
https://learn.microsoft.com/en-us/powerquery-m/sql-database
You can see a ConnectionTimeout parameter that you can use to increase that time and make sure it connects.
Don't go for 30 minutes here because if it fails it could take a lot of time. You can increase by 30 seconds o 1 minute. The parameter takes a #duration value.
I hope that helps,
Hi, thank you for the response. The above did not work. It looks like a firewall, proxy, or routing rules are blocking this connection hence I have reached out to the network team.
If changing the timeouts from your query hasn't changed anything and still send the timeout in the same amount of seconds, then go to the DB team. There might be something on the SQL Server side for timeout the connections or queries.
Regards
