Forum Discussion
Advocate ITrying to play with new ADBC Azure Databricks connector
Hello,
I confirm it works fine now.
In fact, following the ticket I have raised to Microsoft Support team, Databricks team have fixed the driver in september version of Power BI desktop 🙂
Hi maxbarj,
Thank you for reaching out to the Microsoft Fabric Forum Community.
You're currently using the Databricks.Query() function, which just shows a list of databases instead of running your SQL query. To fix this, you need to use the Databricks.Execute() function instead. This function lets you directly run a SQL query on your Databricks connection. You also need to pass the host name, SQL endpoint, your actual query text, and options like the catalog and implementation version. Try Replace the below query inside the quotes with your own.
Databricks.Execute(HostName, SqlEndPoint,
"SELECT col1, col2 FROM ds_rt_admin.data_area_xyz",
[Catalog = Databricks_Catalog, Implementation = "2.0"])
Best regards,
Prasanna Kumar
Advocate IHi Anonymous
Thank you for your reply.
Unfortunately the solution proposed does not work:
I didn't find any documentation on the function Databricks.Execute()
I'm using a custom SQL Query as detailed here: https://learn.microsoft.com/en-us/azure/databricks/partners/bi/power-bi#using-a-custom-sql-query
Without the option
Implementation = "2.0"
The function works fine and return the result of the SQL query.
Kind regards,