Forum Discussion
Solved
Datamart ODBC DSN Timeout
Hi all, Does anyone know if it's possible to set up an ODBC DSN to connect to a Datamart? Our tests keep timing out. [Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: Timeout error [258...
This now works, make sure to have the latest driver:
https://www.oliviertravers.com/power-bi-datamarts-sql-server-desktop-tools-connection/
Hi itchyeyeballs ,
For this type of problem, try the following statement Use "ConnectionTimeout" instead:
Source = Odbc.DataSource("dsn=Production", [value=true, ConnectionTimeout=#duration(0, 0, 15, 0)])
Refer to related document:
Odbc.DataSource - PowerQuery M | Microsoft Docs
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for the response, still no luck though, does seem like it's just not supported.
Error message is the same in the original post.
