Hello Lakshmi Narayana Sarma Bhamidipati, After further research, I found out that we can connect to Azure Analysis Services using the Pyodbc library:
%python import pyodbc
driver = "{ODBC Driver 17 for SQL Server}" server = "your_server.database.windows.net" database = "your_database" username = "your_username" password = "your_password" analysis_services_database = "your_analysis_services_database"
connection_string = f"DRIVER={driver};SERVER={server};DATABASE={database};UID={username};PWD={password};"
conn = pyodbc.connect(connection_string, autocommit=True) cursor = conn.cursor()
query = f"SELECT * FROM {analysis_services_database}..." cursor.execute(query)
This was discussed on the databricks community forum in the below link.
Please try the solution and let me know.