Live Data Connector (ODBC) and Microsoft Login

Paul B
Paul B
edited 01/19/21 in Smartsheet Basics


I'm used to get data from Smartsheet to Excel thanks to the Live Data Connector. However, I can't find a way to use it with a Microsoft login.

When the ODBC driver asks for credentials, the only way to access data is through an API key.

Can someone confirm that we can't use Power Query (with the ODBC connector) with a Microsoft login ?

Thank you !