Forum Discussion
Query folding is disabled when connected with databricks sql direct query
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
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 👍
4 Replies
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 👍
Thanks its working!
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.
Hi, I am still facing this issue, did you figure out any solution ?
