Improve query performance of direct query with Databricks

viniciuscini , Seem like you have tried all.

Ensure good partitioning and clustering of your data for your access patterns. Consider Z-ordering and clustering Optimizations with Delta Lake.

Also, consider Microsoft Fabric. It gives similar data with Direct Lake, where you do need a copy.

You can start a trial.  If your DataBricks table is in Delta format, you can just create shortcuts create model, and check the same in Fabric

Starting Your Free Trial- https://youtu.be/8kIMHmkQ9m4

Shortcuts- https://youtu.be/KIbt9GzAdWk

Hi viniciuscini ,

I think you can try Fabric as amitchandak mentioned.

You may also refer to below offical blogs to optmize Power BI Performance.

For reference:

Optimization guide for Power BI - Power BI | Microsoft Learn

DirectQuery model guidance in Power BI Desktop - Power BI | Microsoft Learn

DirectQuery optimization scenarios with the Optimize ribbon in Power BI Desktop - Power BI | Microsoft Learn

Best Regards,
Rico Zhou

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