Query folding is not been applied even though I am using data bricks as source

[Anonymous]

Query folding is not been applied even though I am using databricks as source. I could see it as disabled. View native query option itself greyed out. Can you please help me out in enabling it.
 

@Anonymous 

[Anonymous · Accepted solution]

Hi @Anonymous ,

Currently, the Databricks connector does not support checking for query folding. This link provides a list of all connectors that support query folding:

Import data from a database using native database query - Power Query | Microsoft Learn
However, you can determine if a query generated by Power Query is folded by looking at the query history in Databricks:

Power Query: Query Folding with Databricks! | by Jason Presley | Medium

Best Regards,
Zhu
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.