Forum Discussion

maxbarj's avatar
maxbarj
Icon for Advocate I rankAdvocate I
1 year ago
Solved

Trying to play with new ADBC Azure Databricks connector

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-d...
Need Help
  • maxbarj's avatar
    maxbarj
    11 months ago

    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 🙂

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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

maxbarj's avatar
maxbarj
Icon for Advocate I rankAdvocate I
1 year ago

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