Forum Discussion
Direct Query mode not applicable for merging two tables with left outer join in azure databricks
We have a large dataset and our requirement is to update a table data and refresh the report. However due to the large size of dataset, in IMPORT mode, it took us around 15-20 mins for dataset refres...
First of all, you should optimize the transformations in Power Query for speed when you import data. Second, the source should be fast itself and this, in turn, calls for SQL optimization (if the source is a SQL query/sproc or a view). If this does not work, then, and only then, should you turn to the DQ mode.