I have PowerQuery importing data from several external folders and the updating is really slow.
Here's the issue:
The data might change for data that's less than 4 weeks old. Earlier stuff won't change, but PQ re-imports EVERYTHING all over again--all 30 weeks' worth of data.
What might be a process for importing just the previous week and refreshing the previous 3 weeks?
Here's the issue:
The data might change for data that's less than 4 weeks old. Earlier stuff won't change, but PQ re-imports EVERYTHING all over again--all 30 weeks' worth of data.
What might be a process for importing just the previous week and refreshing the previous 3 weeks?