What is the difference between Value.NativeQuery and DataBricks.Query

[Anonymous]

Hi ,

I m new to using DataBricks with PBI. 

Is there any difference wrapping Value.NativeQuery over Databricks.Catalog as in Value.NativeQuery(Databricks.Catalog( .... ))

vs calling Databricks.Query?

• Does DataBricks.Query offer any advantage as in support for QueryFolding/ Support for Direct Query?
• For me... Direct  Query is failing from Power BI Desktop with both approaches. With Databricks.Query I m able to see data in Power Query Editor.. but fails when I drag a few fields to the table visual. With Value.NativeQuery  I m unable to use Direct Query
• Does any of the two approaches support Query Folding (for import mode queries)? I couldn't find the native query in the advanced editor(even after including Enable Query Folding option as parameter) so was wondering if I was doing it right.

Thanks & regards,

Mannu

[rajendraongole1]

Hi @Anonymous -Value.NativeQuery over Databricks.Catalog and Databricks.Query depends on your specific requirements and preferences for query complexity, control, and simplicity.Both approaches allow you to run SQL queries against Databricks, but they have different implications and use cases.

Table reference first and then running a native SQL query on top of it using Value.NativeQuery

Databricks.Query this method directly runs a SQL query against Databricks without needing to first create a catalog

Reference:

Value.NativeQuery - PowerQuery M | Microsoft Learn

Connect Power BI to Azure Databricks - Azure Databricks | Microsoft Learn

Hope it helps

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!