Enable Fast Loading for already established Azure Databricks Query

[GSE]

Hi all,

I have a query with a connection to Azure Databricks. The Fast Loading option is not activated since the Databricks cluster was not Version 8.3 or higher at the time the query was set up. Now the cluster version was changed to 8.3 and I would like to enable fast loading. How can I turn on the fast loading option for an already established query? 

Thanks for your help!

[GSE · Accepted solution]

@Anonymous: thanks for the info but I was already aware of that. My question was how to enable the Fast Evaluation option for a query which I already set up and which has the Fast Evaluation option disabled.

I was able to figure it out:

In the Power Query Editor, in the Advanced Editor, you must change the following:

 Change to:

 

[Anonymous]

Hi @GSE 

It’s a new function for Azure Databricks in Power BI September 2021 version . This update adds support for export and import of PBIDS files .More info about new functions for Power BI September 2021 version can refer to the link below .

https://powerbi.microsoft.com/en-us/blog/power-bi-september-2021-feature-summary/#post-17174-_Toc819...

When you connect to Azure Databricks , choose Enabled(Databricks SQL, Databricks Runtime 8.3+) in Fast Evaluation . It enables faster processing of large DirectQuery reports, as well as improved performance of large imports .

Best Regards

Community Support Team _ Ailsa Tao

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