optimize query from power bi desktop

JosephX
New Contributor

How to tuning databricks query performance from Power BI Dosktop

Brahmareddy
Esteemed Contributor II

Hi Joeshph,

How are you doing today?

Give a try with below inputs and let me know if works well.

Filter and aggregate data in Databricks to reduce load before it reaches Power BI. Use DirectQuery carefully, simplify measures, and reduce the number of visuals for better performance. Optimize Databricks clusters, use Delta tables, and regularly maintain your tables with OPTIMIZE and VACCUM commands.

Regards,

Brahma