Any help on this? My dataset is only getting bigger and i need to be able to refresh this faster.
So to be clear i have 4 queries each between 30-40 gbs. I create a consolidated table using merge query in M. But each time i have a new month added to the dataset, it has to reload each query into the consolidated table. So even if i add only one month it has to reload 4 years each time. Any help or suggestions?