Forum Discussion
itchyeyeballs
Impactful Individual
Impactful IndividualDatamart 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/
otravers
Community Champion
Community ChampionIt seems the way they handle authentication is particular as I haven't been able to connect with many tools aside of the officially supported SSMS and ADS. How are you setting up authentication in your DSN? I tried the various AAD authentication options offered by the v18 ODBC SQL driver but like you I'm always getting timeouts when I'm testing the connection.
itchyeyeballsImpactful Individual
Impactful IndividualWe have tried all the possible DSN configurations, suspect it's just not supported. Hopefully will come in time.