topic Re: Trying to play with new ADBC Azure Databricks connector in Power Query

Trying to play with new ADBC Azure Databricks connector

maxbarj — Wed, 16 Jul 2025 08:18:20 GMT

Hello,

I have added in my Databricks function

Implementation="2.0"

as adviced here: https://learn.microsoft.com/en-gb/power-query/connectors/databricks-azure#arrow-database-connectivity-driver-connector-implementation-preview

I'm calling this function in each of my source queries as followed.

But instead of returning the result of the SQL query, it lists the databases.

Any idea on how to fix the Databricks function ?

Thanks !

Re: Trying to play with new ADBC Azure Databricks connector

Anonymous — Thu, 17 Jul 2025 05:09:33 GMT

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

Re: Trying to play with new ADBC Azure Databricks connector

maxbarj — Thu, 17 Jul 2025 08:03:05 GMT

Hi 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,

Re: Trying to play with new ADBC Azure Databricks connector

Anonymous — Fri, 18 Jul 2025 05:03:19 GMT

Hi maxbarj,

Apologies for the confusion in my earlier response I appreciate your patience.

You're absolutely right there is no official Databricks.Execute() function in Power Query. That was a mistake on my part.

The correct approach, as per Microsoft documentation for Databricks + Power BI with Implementation = "2.0", is to use the Databricks.Query() function and pass your SQL inside the Query field like below.

Databricks.Query(HostName,SqlEndPoint,[Catalog = Databricks_Catalog, Query = "SELECT * FROM your_table",Implementation = "2.0"])

Again, apologies for the confusion caused earlier. I hope this clears it up, and let me know if you need help adjusting your existing queries.

Thanks & Regards,

Prasanna Kumar

Re: Trying to play with new ADBC Azure Databricks connector

maxbarj — Fri, 18 Jul 2025 06:19:59 GMT

Hello Anonymous

Solution does not work unfortunately.

It seems query option inside the brackets is not evaluated by power query:

Here is the result if I try to define the Query option outside the brackets:

Thank you for your support

Re: Trying to play with new ADBC Azure Databricks connector

Anonymous — Tue, 22 Jul 2025 03:10:37 GMT

Hi maxbarj,

If the issue still persists, I’d recommend raising a support ticket with Microsoft. The support team can look into the backend and provide more in-depth assistance tailored to your environment.
https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket

Thanks & Regards,

Prasanna Kumar

Re: Trying to play with new ADBC Azure Databricks connector

Anonymous — Thu, 24 Jul 2025 13:19:30 GMT

Hi maxbarj,

Just checking, have you had a chance to open a support ticket, as suggested. If so, we'd love to hear the current status or any updates from that.

If the issue was resolved through the support ticket, it would be great if you could share the solution here as well. It could really help other community members find answers more quickly.

Warm regards,
Prasanna Kumar

Re: Trying to play with new ADBC Azure Databricks connector

maxbarj — Thu, 24 Jul 2025 13:21:48 GMT

Hi,

No, I haven't got time to create the support ticket yet.

Re: Trying to play with new ADBC Azure Databricks connector

Anonymous — Fri, 01 Aug 2025 05:03:41 GMT

Hi maxbarj,

Just checking, have you had a chance to open a support ticket, as suggested. If so, we'd love to hear the current status or any updates from that.

Regards,

Prasanna Kumar

Re: Trying to play with new ADBC Azure Databricks connector

maxbarj — Fri, 01 Aug 2025 13:59:54 GMT

Hi Anonymous ,

I have just opened a support ticket, I will keep you posted here.

Kind regards,

Maxence

Re: Trying to play with new ADBC Azure Databricks connector

maxbarj — Mon, 04 Aug 2025 15:23:54 GMT

Power BI support team informed me they have managed to reproduce the issue and have transfered the case to Databricks team for investigation.

Re: Trying to play with new ADBC Azure Databricks connector

Anonymous — Tue, 05 Aug 2025 06:46:25 GMT

Hi maxbarj,

Thank you for the update. If possible, please share any progress and updates from the Databricks team here as they become available. It will help other community members who are facing the similar issues.

Thanks & Regards,

Prasanna kumar

Re: Trying to play with new ADBC Azure Databricks connector

ManmohanSapEXL — Thu, 02 Oct 2025 14:13:28 GMT

Hi,

I tried this directly with NativeQuery connector & seem to work for me:

"M" Query template below:

let
data = Value.NativeQuery(Databricks.Catalogs(<DatabricksServerName>, <DatabricksHTTPPath>, [Catalog=<DatabricksDatabase>, Implementation="2.0"]){[Name=<DatabricksDatabase>,Kind="Database"]}[Data],"
Select ... From table A Join B On... WHERE ..
", null, [EnableFolding=true])
in data

Or Is yours a different issue?

Re: Trying to play with new ADBC Azure Databricks connector

maxbarj — Thu, 02 Oct 2025 15:33:06 GMT

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 🙂

Re: Trying to play with new ADBC Azure Databricks connector

Anonymous — Fri, 03 Oct 2025 03:45:18 GMT

Hi maxbarj,

Thank you for the update. Could you please accept the specific response that helped resolve the issue. This will assist other community members who may face the same problem.

Thanks & Regards,

Prasanna Kumar