Forum Discussion
Datamart ODBC DSN Timeout
This now works, make sure to have the latest driver:
https://www.oliviertravers.com/power-bi-datamarts-sql-server-desktop-tools-connection/
It 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.
This is why I get confused.
Last month, I was able to access datamart in Python Notebook and there was running log to prove it.
yet, it doesn't work anymore when I tried to re-run the notebook this week.
I wonder whether it has been blocked somehow. I don't know who could confirm it tho.