Query folding is disabled when connected with databricks sql direct query

[chaitubh]

Hello Everyone,

I connected power bi with Databricks SQL end points using Azure Databricks connection. i connected it with direct query mode. i didnt applied anysteps in transformdata(Query Editor)... still the query folding is disabled. I tried import mode also still im not able to see query folding. Please suggest.

Refernce screenshot,

Thanks,

Chaitanya

[Anonymous]

Hi @chaitubh & @Idrissshatila ,

I tried the linkedin solution and it worked fine in the transform data page. I connect it with direct query mode. But when I clicked close and apply button, I encountered below error. I never encountered this error when using value.NativeQuery / Databricks.Catalog. Have you encountered this error before, and if so, could you please share how you resolved it? Thanks in advance.

[ShreyasCaaS]

Hi, I am still facing this issue, did you figure out any solution ?

[chaitubh]

Thanks its working!

[Idrissshatila · Accepted solution]

Hello @chaitubh ,

Check this article, it will help solve your problem https://www.linkedin.com/pulse/query-folding-azure-databricks-tushar-desai/

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin