Hi,
I have a powerbi server which I'm able to connect through SSMS. I tried using pyodbc to connect to same in databricks, but it is throwing below error.
OperationalError: ('HYT00', '[HYT00] [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired (0) (SQLDriverConnect)')
As per what I've researched, powerbi metadata is SSAS and not odbc, so we cant connect through pyodbc. Let me know if my understanding is incorrect.
Please suggest alternative library or approach how to achieve this through python.
