Forum Discussion

maxbarj's avatar
maxbarj
Advocate 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
    10 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 🙂

ManmohanSapEXL's avatar
ManmohanSapEXL
New Member
10 months ago

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?

 

  • maxbarj's avatar
    maxbarj
    Advocate I
    10 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 🙂