Vetrivel
Databricks Partner

@Sidhant07 The issue is not related to the volume of data, as it is relatively small. Rather, the challenge lies in the time it takes to generate the plan in Databricks, which results in the process being automatically cancelled. Consequently, we are unable to retrieve the complete query from the query history. Additionally, we cannot modify the query generated by PowerBI at this time. We have already implemented liquid clustering for the FACT and DIM tables.